CHISQ.DIST.RT Function
Returns the right-tailed chi-square distribution — a chi-square test p-value.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
The chi-square distribution describes sums of squared differences — it underlies tests of whether counts match what you expected and of whether two categories are related. It's always positive and skewed to the right.
CHISQ.DIST.RT returns the probability of a value greater than x: the p-value for a chi-square statistic you've calculated yourself. 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.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The chi-square statistic; can't be negative. |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
Examples
Example 1 — Are tickets spread evenly across the week?
120 support tickets would be 24 a day if spread evenly. The statistic adds up (observed − expected)² ÷ expected.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Day | Tickets | Expected | Measure | Result |
| 2 | Mon | 28 | 24 | Statistic | 3.75 |
| 3 | Tue | 22 | 24 | p-value | 0.4409 |
| 4 | Wed | 19 | 24 | ||
| 5 | Thu | 21 | 24 | ||
| 6 | Fri | 30 | 24 |
With 5 days there are 4 degrees of freedom. p ≈ 0.44, so the busier Monday and Friday could easily be chance — the same answer CHISQ.TEST gives in one step.
Common mistakes
- #NUM! x is negative, or deg_freedom is less than 1.
- Degrees of freedom. For a list of categories it's the count minus 1; for a table, (rows − 1) × (columns − 1).
Notes
- CHISQ.DIST.RT replaces the older CHIDIST function.
- Related functions: CHISQ.TEST, CHISQ.INV.RT, CHISQ.DIST.

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.