# Documentation/Calc Functions/CHITEST

From The Document Foundation Wiki

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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.