Documentation/Calc Functions/CHITEST

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

CHITEST

Category:

Statistical Analysis

Summary:

Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence. CHITEST returns the chi-squared distribution of the data.

Syntax:

CHITEST(DataB; DataE)

Returns:

Arguments:

DataB is the array of the observations.

DataE is the range of the expected values.

Additional details:

The probability determined by CHITEST can also be determined with CHIDIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.

Examples:

Data_B (observed) Data_E (expected)
1 195 170
2 151 170
3 148 170
4 189 170
5 183 170
6 154 170

=CHITEST(A1:A6;B1:B6) equals 0.02. This is the probability which suffices the observed data of the theoretical Chi-square distribution.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: