The `CHIDIST` function in Excel is used to calculate the one-tailed probability of the chi-square distribution, which is commonly used in hypothesis testing. This function is particularly useful in statistical analysis for goodness-of-fit tests or chi-square tests of independence.
Syntax
CHIDIST(x, degrees_freedom)
- `x`: The value at which you want to evaluate the distribution. It must be greater than or equal to 0.
- `degrees_freedom`: The degrees of freedom for the distribution. It must be a positive integer.
Important Notes
- Deprecation: `CHIDIST` has been replaced with the `CHISQ.DIST.RT` function in Excel 2010 and later. Although `CHIDIST` is still available for compatibility reasons, it’s recommended to use `CHISQ.DIST.RT` for newer versions.
- Function Result: The function returns a probability that corresponds to the chi-square distribution’s right tail, indicating how likely it is to achieve a chi-square statistic that is greater than or equal to `x`.
Example
Assuming you want to calculate the probability of a chi-square statistic with a value of 4 and 2 degrees of freedom, you would use the formula:
=CHIDIST(4, 2)
This function will return the right-tailed probability associated with the chi-square value of 4 for the specified degrees of freedom.
Using CHISQ.DIST.RT
For newer versions of Excel, consider using:
=CHISQ.DIST.RT(4, 2)
This will give you the same result as `CHIDIST` but adheres to the updates made in the statistical functions of newer Excel versions.
Always ensure you understand the context of your statistical tests to use the chi-square functions appropriately.
Unlock Your Potential
Excel
Access
Power BI
