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




Name Description Data Type Required/
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.
boolean Required

Remarks :

  • 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.

excel chisq dot dist

Example - 2 : The chi-squared distribution for 3, returned as the probability density function, using 1 degrees of freedom.

excel chisq dot dist 2