Documentation/How Tos/Calc: CHITEST function

CHITEST

Returns a measure of χ² 'goodness of fit'.

Syntax:

CHITEST(observed; expected)

observed and expected are ranges or arrays of observed and expected values. They must have the same number of rows and columns and there must be at least 2 values in each.

CHITEST calculates the χ² statistic and degrees of freedom, then calls CHIDIST.

Example:

CHITEST({8;9;7;8}; {8;8;8;8})

returns approximately 0.969.

Issues:

• The draft international standard ODFF calls this function LEGACY.CHITEST, and points out that it has limited mathematical validity. CHITEST is compatible with the Excel CHITEST function.