ReferenceFunctionsStatistics Functions
CHISQ.TEST
CHISQ.TEST: Returns the right-tail p-value from a chi-square goodness-of-fit style comparison.
Summary
CHISQ.TEST compares observed and expected values and computes 1 - CHISQ.DIST(...).
Remarks
actual_rangeandexpected_rangemust contain the same number of numeric points.- Expected values must be strictly greater than
0. - Requires at least two categories (
df >= 1). - Returns
#N/Afor length mismatches or empty inputs, and#NUM!for invalid expected values.
Examples
Perfect match between observed and expected
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
1
Two-category chi-square test
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.5270892568655381
Related functions
Runtime metadata
Category
Statistics
Signature
CHISQ.TEST(arg1: Number (Range), arg2: Number (Range))Arity
min 2, max 2
Arguments
arg1Number · Range · coercion NumberLenientText
arg2Number · Range · coercion NumberLenientText
Caps
PURE
Source