Statistical - CHISQ.INV Function

Description

The CHISQ.INV function returns the inverse of the left-tailed probability of the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples.

Syntax

CHISQ.INV (probability,deg_freedom)

Arguments

Argument	Description	Required/ Optional
Probability	A probability associated with the chi-squared distribution.	Required
Deg_freedom	The number of degrees of freedom.	Required

Notes

If deg_freedom is not an integer, it is truncated.
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 < 1 or deg_freedom > 10^10, CHISQ.INV returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm