CHIDIST
Syntax:
CHIDIST ( x , degrees-freedom )
Description: Computes the one-tailed probability of the chi-squared distribution.
Mathematical Formula:
CHIDIST = P(X>x), where X is a χ2 random variable.
Arguments:
Name |
Type |
Description |
|---|---|---|
x |
number |
The value at which the distribution is to be evaluated. |
degrees-freedom |
number |
The number of degrees of freedom, truncated to an integer. |
Return Type and Value: number – The one-tailed probability of the chi-squared distribution.
However, if
x < 0,
#NUM!is returned.degrees-freedom < 1 or degrees-freedom > 1010,
#NUM!is returned.
example: