Excel CHISQ.DIST() function
The CHISQ.DIST() function is used to get the chi-squared distribution.
The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching movies in television.
Version: Excel 2013
|X||The value at which you want to evaluate the distribution.||number||Required|
|Deg_freedom||The number of degrees of freedom.||number||Required|
|Cumulative||A logical value that determines the form of the function.
If cumulative is TRUE, CHISQ.DIST returns the cumulative distribution function;
if FALSE, it returns the probability density function.
- If any argument is nonnumeric, CHISQ.DIST returns the #VALUE! error value.
- If x is negative, CHISQ.DIST 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.DIST returns the #NUM! error value.
Example - 1: Excel CHISQ.DIST() function
In the following example the chi-squared distribution for 0.3, returned as the cumulative distribution function, using 1 degree of freedom.
Example - 2 : The chi-squared distribution for 3, returned as the probability density function, using 1 degrees of freedom.