CHISQ.INV (Probability, DegreesOfFreedom) CHISQ.INV (Probability; DegreesOfFreedom)
Probability
Number Number
The probability, which must be between 0 and 1.
DegreesOfFreedom
Number Number
The degrees of freedom for the distribution.
Returns
Number Number
The value at which the cumulative chi-squared distribution equals the given probability.
Returns the inverse of the cumulative CHISQ.DIST function. Given a probability and degrees of freedom, this function returns the value at which the cumulative chi-squared distribution equals the given probability. This is useful for determining critical values in chi-squared hypothesis tests.
Example
CHISQ.INV (0.5, 9)
CHISQ.INV (0,5; 9)
Returns roughly 8.34.