Documentation/Calc Functions/CHISQ.TEST

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

CHISQ.TEST

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. CHISQ.TEST returns the chi-squared distribution of the data.

Syntax:

CHISQ.TEST(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 CHISQ.TEST can also be determined with CHISQ.DIST, 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

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

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: