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: