Formulas and Functions

Chapter 10 Statistical Functions 239
CHIDIST
The CHIDIST function returns the one-tailed probability of the chi-square distribution.
CHIDIST(non-neg-x-value, degrees-freedom)
 non-neg-x-value: The value at which you want to evaluate the function. non-neg-x-
value is a number value that must be greater than or equal to 0.
 degrees-freedom: Degrees of freedom. degrees-freedom is a number value and
must be greater than or equal to 1.
Examples
=CHIDIST(5, 2) returns 0.0820849986238988.
=CHIDIST(10, 10) returns 0.440493285065212.
=CHIDIST(5, 1) returns 0.0253473186774683.
Related Topics
For related functions and additional information, see:
“CHIINV” on page 239
“CHITEST” on page 240
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
CHIINV
The CHIINV function returns the inverse of the one-tailed probability of the chi-square
distribution.
CHIINV(probability, degrees-freedom)
 probability: A probability associated with the distribution. probability is a number
value and must be greater than 0 and less than 1.
 degrees-freedom: Degrees of freedom. degrees-freedom is a number value and
must be greater than or equal to 1.