The CHIINV function returns the inverse of the one-tailed probability of the chi-square distribution. Both arguments are number values.
CHIINV(probability, degrees-freedom)
probability: The probability associated with the distribution. probability must be greater than 0 and less than 1.
degrees-freedom: The number of degrees of freedom. degrees-freedom must be greater than or equal to 1.
Examples |
|---|
=CHIINV(0.5, 2) returns 1.38629436111989. =CHIINV(0.1, 10) returns 15.9871791721053. =CHIINV(0.5, 1) returns 0.454936423119572. |