Syntax. CHISQ.DIST(x,degrees_freedom,cumulative)

Definition. This function returns the values of the chi-squared distribution. The chi-squared distribution is often used to examine the variance across samples. For example, you can calculate the percentage of time people spend every day watching TV.


  • x (required). The value (quantile) for which you want to calculate the probability (1-alpha).

  • degrees_freedom (required). The number of degrees of freedom.

  • cumulative (required). The logical value. If cumulative is TRUE, the cumulative distribution is returned; otherwise, the probability density function is returned.


If one of the arguments isn’t a numeric value, the CHISQ.DIST() function returns the #VALUE! error.

If x is negative, ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.