Excel like a finance pro.
← The libraryPractice · 2 questions →
Compatibility function
CHITEST
Returns the chi-squared test for independence; replaced by CHISQ.TEST.
Rarely usedDifficulty 1450 · AdvancedUsage rank #428 of 520
When to use it
The chi-squared test of independence. Replaced by CHISQ.TEST with identical arguments.
The shape of it
- Syntax
=CHITEST(actual_range, expected_range)
Worked examples
2 by 2
=CHITEST({30,20;20,30},{25,25;25,25}) → 0.045500264
A 2×2 table.
3 by 2
=CHITEST({58,35;11,25;10,23},{45.35,47.65;17.56,18.44;16.09,16.91}) → 0.000308
A 3×2 table: strong evidence of a relationship.
From ranges
=CHITEST(B2:D4,E2:G4) → 0.31
A 3×3 table from ranges.
Worth knowing
- Same as CHISQ.TEST.
- Expected counts must be built separately.
- Degrees of freedom are (r-1)(c-1).
Where it goes wrong
- #N/A when the tables differ in shape.
- Flagged by the Compatibility Checker.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.