CHIDIST Function

The Excel CHIDIST function retrieves the chi-squared distributions right-tailed probability. It is based on the Chi-squared test, which contrasts the given dataset's expected and observed values, where you can make the decision whether to accept the hypothesis's validity or not. The CHIDIST function interchanges the CHISQ.DIST.RT function from Excel 2010.

Compatibility

This advanced Excel function is compatible with the following versions of MS-Excel −

Excel for Microsoft 365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2021
Excel 2021 for Mac
Excel 2019
Excel 2019 for Mac
Excel 2016

Syntax

The formula of the CHIDIST function is given below −

CHIDIST(x,deg_freedom)

Arguments

You can use the following arguments with the CHIDIST function −

Argument	Description	Required / Optional
X	It specifies the numerical value to compute the CHIDIST function.	Required
Deg_freedom	It specifies a certain number of degrees of freedom.	Required

Points to Remember

The mathematical notation is CHIDIST = P(t > x), where t specifies t2 random variable.
If the second argument, deg_freedom, specifies a decimal value, then its values get truncated and converted into integers.
If any argument contains a value other than integers, then the CHIDIST function will retrieve the #VALUE! error.
If x is less than zero, CHIDIST will retrieve the #NUM! Error.
If deg_freedom is less than one or deg_freedom greater than 10^10, then the CHIDIST function retrieves the #NUM! error.

Examples of CHIDIST Function

Practice the following examples to learn the use of the CHIDIST function in Excel.

Example 1

Consider the sample dataset where you may write the X and Degree of Freedom argument values in the B2 and B3 cells. The significance level value is 0.05 given in the B4 cell to check the validity of the hypothesis. You may enter the formula =CHIDIST(B2,B3) in the B5 cell and press the Enter tab.

Therefore, the final result is 0.0046, less than the significance level of 0.05, which means the null hypothesis will be rejected.

Example 2

If the second argument, deg_freedom, specifies a decimal value, then its values get truncated and converted into integers.

Solution

First, you may write the X and degree of freedom arguments associated values in the B2 and B3 cells. Enter the formula =CHIDIST(B2,B3) in the B4 cell and press the Enter tab.

Note − The value of the degree of freedom argument 12.7 is truncated.

Example 3

If any argument contains a value other than integers, then the CHIDIST function will retrieve the #VALUE! error.

Solution

Consider the sample dataset, where the X argument contains the non-numeric value Henry, and the Degree of Freedom argument contains the integer value 10 mentioned in the B2 and B3 cells. You may enter the formula =CHIDIST(B2,B3) in the B4 cell and press the Enter tab.

Therefore, it is proven that the CHIDIST function will retrieve the #VALUE! Error for the non-numeric arguments.

Example 4

If x is less than zero, CHIDIST will retrieve the #NUM! Error.

Solution

You may set the X value to -14 in the B2 cell and the Degree of Freedom value to 10. You may type the formula =CHIDIST(B2,B3) in the B4 cell and click the Enter tab.

Therefore, the resulting value #NUM! is obtained by the CHIDIST function.

Example 5

If deg_freedom is less than one or deg_freedom greater than 10^10, then the CHIDIST function retrieves the #NUM! error.

Solution

First, you can alter the X value to 34, type -12 in the B3 cell, write the expression =CHIDIST(B2,B3) in the B4 cell, and then press the Enter tab.

Therefore, the CHIDIST function will retrieve the #NUM! Error if the degree of freedom contains a negative value. Make sure that both arguments should contain the positive numeric values.

Save or share this article