Functions
CHITEST
Chi-squared test (legacy)
Try it
When to use it
When should I use CHITEST?
Use CHITEST to compute the p-value for a chi-squared goodness-of-fit test — it is the legacy equivalent of CHISQ.TEST, retained for compatibility with older spreadsheets.
Used in
Syntax
CHITEST(observed,expected)Examples
=CHITEST({11;15;8;10;2;14},{10;10;10;10;10;10}) // => 0.05137998348306949