Did you know that the OpenOffice.org Wiki has a WYSIWYG editor? See Help:FCKeditor

Documentation/How Tos/Calc: CHITEST function

From OpenOffice.org Wiki

Jump to: navigation, search


CHITEST

Returns a measure of χ2 '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 χ2 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.

See Also

Personal tools
Create a book