Calculates the inverse of the CHISQDIST function.
Syntax
CHISQINV(p, k)
k is the degrees of freedom for the .
Constraint: k must be a positive integer
p is the given probability
Constraint: 0 ≤ p < 1
Semantic
CHISQINV(p, k) returns the value x, such that CHISQDIST(x, k,TRUE()) = p.
Example
CHISQINV(0.5, 9)
returns approximately 8.342832692
.
Remarks
If you need CHISQINV(p,k) for a non interger parameter k, then use GAMMAINV(p,k/2,2) instead