Functions
CHISQ.TEST
Chi-squared goodness of fit test
Try it
When to use it
When should I use CHISQ.TEST?
Use CHISQ.TEST to obtain the p-value for a chi-squared goodness-of-fit or independence test, comparing observed counts to expected counts — the modern replacement for CHITEST.
Used in
Syntax
CHISQ.TEST(observed,expected)Examples
=CHISQ.TEST({11;15;8;10;2;14},{10;10;10;10;10;10}) // => 0.05137998348306949