CHISQ.INV:
Returns the inverse of the lefttailed probability of the chisquared distribution
The CHISQ.INV function returns the inverse of the lefttailed probability of the chisquared distribution. The chisquared distribution is
commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend driving cars.
Using the CHISQ.INV function:
The arguments for the CHISQ.INV function are:
Argument

Required?

Description

probability 
Required 
A probability associated with the chisquared distribution. 
deg_freedom 
Required 
The number of degrees of freedom. 
• If argument is nonnumeric, CHISQ.INV returns the #VALUE! error value. 
• If probability < 0 or probability > 1, CHISQ.INV returns the #NUM! error value. 
• If deg_freedom is not an integer, it is truncated. 
• If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.INV returns the #NUM! error value. 
The CHISQ.INV function returns the inverse of the lefttailed probability of the chisquared distribution. The chisquared distribution is
commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend driving cars.