CHISQ.DIST Function

Basic Description

The Excel Chisq.Dist function calculates the Probability Density Function or the Cumulative Distribution Function for the chi-square distribution. The function is new in Excel 2010 and so is not available in earlier versions of Excel.

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

where the function arguments are:

x The value at which the chi-square distribution is to be evaluated (must be ≥ 0)
degrees_freedom
The number of degrees of freedom (must be an integer between 1 and 1010)

(If the supplied value is a decimal, this is truncated to an integer)

cumulative A logical argument that specifies the type of chi-square distribution to be calculated. This can be either:

TRUE calculate the cumulative distribution function
FALSE calculate the probability density function

 

Chisq.Dist Function Examples

Example 1 – Probability Density Function

The chart on the right shows the probability density function for the chi-square distribution with 1, 2 & 3 degrees of freedom.

If you want to calculate the value of any of these functions for a specified value of x, this can be done using the Chisq.Dist function.

For example, the value of the probability density function with 2 degrees of freedom, at x = 3 is calculated by the following:

=CHISQ.DIST( 3, 2, FALSE )

This gives the result 0.11156508.

Plot of the Probability Density Chi-Square Distribution with 1, 2 & 3 degrees of freedom

Chi-Square Probability Density Dist. with 1, 2 & 3 degrees of freedom
Example 2 – Cumulative Distribution Function

The chart on the right shows the Cumulative Chi-Square Distribution function with 1, 2, & 3 degrees of freedom.

If you want to calculate the value of any of these functions for a specified value of x, this can be done using the Chisq.Dist function.

For example, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3, is calculated by the following:

=CHISQ.DIST( 3, 2, TRUE )

This gives the result 0.77686984.

Plot of the Cumulative Chi-Square Distribution with 1, 2 & 3 degrees of freedom

Cumulative Chi-Square Distribution with 1, 2 & 3 degrees of freedom

 

Chisq.Dist Function Errors

If you get an error from the Excel Chisq.Dist function this is likely to be one of the following :

#NUM! Occurs if either the supplied value of x is negative or the supplied degrees_freedom argument is <1 or >1010
#VALUE! Occurs if any of the supplied arguments are not recognised as numeric values

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment