CHISQ.DIST function

The CHISQ.DIST function in Excel returns the cumulative distribution function (CDF) of the chi-squared distribution, which is commonly used in hypothesis testing, particularly for tests of independence and goodness-of-fit.

Syntax:

CHISQ.DIST(x, deg_freedom, cumulative)

Arguments:

• x: The value at which you want to evaluate the chi-squared distribution (a positive number).
• deg_freedom: The number of degrees of freedom for the distribution (a positive integer).
• cumulative: A logical value that determines the type of function to return:
  • TRUE: Returns the cumulative distribution function (CDF), which gives the probability that a chi-squared variable is less than or equal to x.
  • FALSE: Returns the probability density function (PDF), which gives the height of the chi-squared distribution at x.

Example:

If you want to calculate the cumulative chi-squared distribution for a value of 5, with 10 degrees of freedom, you would use:

=CHISQ.DIST(5, 10, TRUE)

This will return the cumulative probability for a chi-squared distribution with 10 degrees of freedom at the value of 5.

For the probability density function, use:

=CHISQ.DIST(5, 10, FALSE)

This will return the value of the probability density at x = 5 for the given distribution.