Difference between revisions of "Documentation/How Tos/Calc: CHITEST function"

Revision as of 09:17, 17 July 2018

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.

• CHIDIST
• CHIINV

• Statistical functions

• Functions listed alphabetically
• Functions listed by category