CHIDIST function

FUNCTIONS

Spreadsheet Lookup functions

Measures of dispersion / spread

Probability and statistics

Correlation and line fitting

See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND

Ranking

CHIDIST

Calculates values for a χ²-distribution.

CHIDIST(x; k)

k is the (positive integer) degrees of freedom for the χ²-distribution.

x is a number >=0.

CHIDIST returns the right tail probability for the χ²-distribution:

The international standard ODFF calls this function LEGACY.CHIDIST, and defines a new CHISQDIST function. * CHISQDIST was expected for OOo 3.1
The international standard ODFF has no restriction for x, but defines that LEGACY.CHIDIST returns 1 for x ≤ 0.

CHIDIST(2; 3)

returns approximately 0.5724.

See Also