Returns 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 television.

Sample Usage



The CHISQ.DIST function syntax has the following arguments:

  • X     Required. The value at which you want to evaluate the distribution.

  • Deg_freedom     Required. The number of degrees of freedom.

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

In order to use the CHISQ.DIST formula, start with your edited Excellentable:

Then type in the CHISQ.DIST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the CHISQ.DIST formula for, Excellentable will generate the outcome:


User does not have sufficient privileges to access this Content
Learn More