Documentation/How Tos/Calc: CHITEST function

From Apache OpenOffice 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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_CHITEST_function&oldid=243557"
Views
Personal tools
Navigation
Print/export
Tools