CHISQ.INV.RT (Probability, DegreesOfFreedom) CHISQ.INV.RT (Probability; DegreesOfFreedom)
Probability
Number Number
The probability, which must be greater than 0 and at most 1.
DegreesOfFreedom
Number Number
The degrees of freedom for the distribution.
Returns
Number Number
The value at which the right-tailed chi-squared distribution equals the given probability.
Returns the inverse of the right-tailed CHISQ.DIST.RT function. Given a probability, this function returns the value that the chi-squared distribution exceeds with that probability. This is the critical value of a chi-squared test at the significance level given by the Probability parameter.
Example
CHISQ.INV.RT (0.05, 10)
CHISQ.INV.RT (0,05; 10)
Returns roughly 18.31.