Compatibility - CHIDIST Function
The CHIDIST function replaces the CHISQ.DIST.RT function from Excel 2010.
Description
The function returns the right-tailed probability of the chi-squared distribution. The X2 distribution is associated with a X2 test. Use the X2 test to compare the observed and the expected values. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.
Syntax
CHIDIST(x,deg_freedom)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
X | The value at which you want to evaluate the distribution. | Required |
Deg_freedom | The number of degrees of freedom. | Required |
Notes
CHIDIST is calculated as CHIDIST = P(X > x), where X is a X2 random variable.
If deg_freedom is not an integer, it is truncated.
If either argument is nonnumeric, CHIDIST returns the #VALUE! error value.
If x is negative, CHIDIST returns the #NUM! error value.
If deg_freedom < 1 or deg_freedom > 10^10, CHIDIST returns the #NUM! error value.