Syntax
CHITEST(actual_range, expected_range)
| Parameter | Description |
|---|---|
| actual_range | Parameter of the CHITEST function. |
| expected_range | Parameter of the CHITEST function. |
Examples
Gender and preference test
Formula
=CHITEST(A2:B3, D2:E3)
Returns the p-value for a 2x2 test of whether gender (rows) is associated with product preference (columns).
Goodness-of-fit for traffic
Formula
=CHITEST(A2:A8, B2:B8)
Tests whether daily traffic counts follow a uniform distribution by comparing observed counts (A) to equal expected counts (B).
Marketing channel effectiveness
Formula
=CHITEST(C2:E3, G2:I3)
Tests whether conversion rates differ across 3 marketing channels and 2 customer segments.
Common Errors
#N/A
Actual and expected ranges must have identical dimensions.
#NUM!
Expected values must all be positive.
Tips
Use CHISQ.TEST instead
CHITEST is the compatibility version. CHISQ.TEST is the modern replacement with identical behavior.
One-dimensional or two-dimensional
CHITEST works with both single-row/column ranges (goodness-of-fit) and multi-row/column ranges (test of independence). The function handles both automatically.
Always uses raw counts
Pass raw frequency counts, not percentages or proportions. The test requires actual counts to compute the chi-squared statistic correctly.
Try CHITEST in Viztab
Import your data and use CHITEST with 370+ other formulas. No signup required.
Open Viztab