CHIDIST Function

Basic Description

The Excel Chidist function calculates the right-tailed probability of the chi-square distribution

Syntax: CHIDIST( x, degrees_freedom )

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 degrees_freedom is a decimal, this is truncated to an integer)

 

Chidist Function Examples

Chi-Square Right-Tailed Distribution with 1, 2 and 3 Degrees of Freedom

  Right-tailed chi-square dist. with 1, 2 & 3 degrees of freedom

The chart on the right shows the right-tailed chi-square distribution, with 1, 2 and 3 degrees of freedom. The value of any of these functions, at a specified value of x can be calculated using the Excel Chidist function. This is shown in the spreadsheets below:

 Formulas:

Examples of use of the Excel Chidist Function

 Results:

Excel Chidist Function Results

 

Chidist Function Errors

If you get an error from the Excel Chidist 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 either 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