Excel - CHISQ.DIST Function
CHISQ.DIST Function
The Excel CHISQ.DIST function is a part of the Statistical function and was first introduced in Excel 2010. It is employed to obtain the left-tailed probability and evaluate the chi-squared value. For instance, using the CHISQ.DIST function, the likelihood of the Type 2 error is calculated with a chi-square value of.18 and a deg of freedom of 4. Before Excel 2010, this function was not available in earlier versions of Excel.
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 2024
- Excel 2024 for Mac
- Excel 2021
- Excel 2021 for Mac
- Excel 2019
- Excel 2016
- Excel Web App
- Excel 2013
- Excel 2010
Syntax
The syntax of CHISQ.DIST function is as follows −
=CHISQ.DIST(x,deg_freedom,cumulative)
Arguments
You can use the following arguments with the CHISQ.DIST function −
| Argument | Description | Required/Optional |
|---|---|---|
| X | It represents the positive integer value to evaluate the computation. | Required |
| Deg_freedom | A numeric value that represents the degree of freedom. | Required |
| Cumulative | It indicates a Boolean value that is either TRUE or FALSE. If its value is equivalent to TRUE, then CHISQ.DIST function will retrieve the cumulative distribution function. Otherwise, it will retrieve the probability density function. | Required |
Points to Remember
- If deg_freedom argument contains a decimal value, it is truncated.
- If any argument contains a value other than numeric, then the CHISQ.DIST function will return the #VALUE! error.
- If x<1, then the CHISQ.DIST function will retrieve the #NUM! error.
- If deg_freedom doesn’t lie between 1 and 10^10, then the CHISQ.DIST function will retrieve the #NUM! error.
Examples of CHISQ.DIST Function in Excel
Practice the following examples to get the master proficiency in the CHISQ.DIST function in Excel.
Example 1
How to calculate the cumulative distribution function using CHISQ.DIST() function in Excel?
In this example, we will apply the CHISQ.DIST() function to obtain the cumulative distribution function.
Solution
The likelihood and degree of freedom values are 5 and 4 as specified in the B3 and C3 cells. Write the formula =CHISQ.DIST(B3,C3,D3) in the C4 cell and hit the Enter.
Therefore, the CHISQ.DIST() function returns 0.4561, representing the cumulative distribution function.
Example 2
If any argument contains a value other than numeric, then the CHISQ.DIST function will return the #VALUE! error.
Solution
You can enter the formula =CHISQ.DIST("xy","twenty",FALSE) in the D3 cell. Here, text values are depicted in the probability and deg_of freedom arguments.
Therefore, the CHISQ.DIST function will retrieve the #VALUE error.
Example 3
If x<1, then the CHISQ.DIST function will retrieve the #NUM! error.
Solution
Navigate to the example3 sheet and write the formula =CHISQ.DIST(-23,4,FALSE) in the B2 cell. In this expression, the value of x is -23, which is not permissible in this function.
Hence, the CHISQ.DIST function retrieves the #NUM! error.
Example 4
If deg_freedom doesnt lie between 1 and 10^10, then the CHISQ.DIST function will retrieve the #NUM! error.
Solution
You can enter the formula =CHISQ.DIST(3,-1,FALSE) in the B3 cell and press the Enter tab.
Therefore, the CHISQ.DIST function returns the #NUM! error.
Download Practice Sheet
You can download and use the sample data sheet to practice the CHISQ.DIST function.