CHISQ.TEST Function
Returns the p-value of a chi-square test comparing observed and expected counts.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
CHISQ.TEST checks whether counts differ from what you expected more than chance would explain — tickets by weekday, sales by region, answers to a survey. It returns the p-value. A p-value is the chance of seeing a difference at least this big if there were really no difference. Below 0.05 is the usual cut-off for calling a result statistically significant.
You supply the expected counts yourself. For a table testing whether two categories are related, the expected count for each cell is row total × column total ÷ grand total.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| actual_range | Yes | The observed counts. |
| expected_range | Yes | The expected counts, the same shape. |
Examples
Example 1 — Are tickets spread evenly across the week?
Observed tickets per weekday against an even 24 a day.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Day | Tickets | Expected | Measure | Result |
| 2 | Mon | 28 | 24 | p-value | 0.4409 |
| 3 | Tue | 22 | 24 | ||
| 4 | Wed | 19 | 24 | ||
| 5 | Thu | 21 | 24 | ||
| 6 | Fri | 30 | 24 |
p ≈ 0.44 — no real evidence that some days are busier than others.
Common mistakes
- Counts only. Use raw counts, not percentages or averages.
- Small expected counts. The test is unreliable when expected counts are below about 5.
- #N/A The two ranges hold different numbers of values.
Notes
- Degrees of freedom are worked out automatically: count − 1 for a single row or column, (rows − 1) × (columns − 1) for a table.
- CHISQ.TEST replaces the older CHITEST function.
- Related functions: CHISQ.DIST.RT, CHISQ.INV.RT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.