CHITEST
Returns the test for independence.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Legacy version of CHISQ.TEST.
Syntax
CHITEST(actual_range, expected_range)
Arguments
actual_range(range) — Observed data.expected_range(range) — Expected data.
Examples
Legacy Test
Calculate p-value (Legacy).
FORMULA
=CHITEST(A2:B2, A3:B3)
RESULT
0.0002
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Cat1 | Cat2 |
| 2 | 58 | 11 |
| 3 | 35 | 25 |