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:

CHIDIST(3.5,4) results in 0.47787835
CHIDIST(12.34,7) results in 0.089917721

end example]