The CHISQ.INV function returns the inverse of the "left-tailed" chi-square distribution function.
CHISQ.INV(
probability,
deg_freedom
)
- probability: Probability associated with the chi-square distribution.
- deg_freedom: Number of degrees of freedom to consider in the distribution.
The CHISQ.INV function returns a real number.
If any of the arguments are not numeric, the function returns the #VALUE! error.
If the probability is less than 0 or greater than 1, CHISQ.INV returns the #NUM! error.
If deg_freedom is a real number, it is rounded.
If deg_freedom is less than 1 or greater than 10 10, the function returns the #NUM! error.
In this example, the inverse of the chi-square distribution is calculated for the probability value 0.93 with 1 degree of freedom: