Updated: 9 August 2010

Use CHIDIST to calculate the one-tailed probability of the chi-square distribution. The chi-square distribution is associated with a chi-squared result. The chi-square distribution is a special case of the gamma distribution. Its cumulative distribution function is:

SELECT [wctStatistics].[wct].[CHIDIST] (

<@X, float,>

,<@Degrees_freedom, float,>)

is any real positive number. @*X *is an expression of type **float** or of a type that can be implicitly converted to **float**.

is any real positive number. @*Degrees_freedom *is an expression of type **float** or of a type that can be implicitly converted to **float**.

float

· If *@X* < 0, CHIDIST returns an error.

· *@Degrees_freedom* is truncated to zero decimal places

· if *@Degrees_freedom* < 1 or *@Degrees_freedom* > 10^10, CHIDIST returns an error.

· CHIDIST = 1-GAMMADIST(*@X*,*@Degrees_freedom*/2,2,'True')

select wct.CHIDIST(15.0862724691398, 5)

This produces the following result

----------------------

0.0100000000000011

(1 row(s) affected)

select 1-wct.GAMMADIST(15.0862724691398,2.5,2,'True')

This produces the following result

----------------------

0.0100000000000011

(1 row(s) affected)