CHIINV

Definition: CHIINV is a function that returns the inverse of the one-tailed probability of the chi-squared distribution.

Syntax: =CHIINV(probability, degrees_freedom)

Situation: This formula is suitable when you need to find the value of the chi-squared distribution that corresponds to a given probability.

Example: If you have a chi-squared distribution with 4 degrees of freedom and a probability of 0.05, the value can be found using the formula =CHIINV(0.05, 4), which returns a value of 9.488.