CHISQ.INV.RT Function
Returns the inverse of the right-tailed chi-square distribution — the critical 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.INV.RT returns the value with the given probability above it: the critical value a chi-square statistic must beat to be significant.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The right-tail probability (significance level), from 0 to 1. |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
Examples
Example 1 — Critical value for the ticket test
The weekday test has 4 degrees of freedom.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Day | Tickets | Expected | Measure | Result |
| 2 | Mon | 28 | 24 | Statistic | 3.75 |
| 3 | Tue | 22 | 24 | Critical (5%) | 9.4877 |
| 4 | Wed | 19 | 24 | ||
| 5 | Thu | 21 | 24 | ||
| 6 | Fri | 30 | 24 |
The statistic (3.75) is well below the critical value (9.49), so the difference isn't significant.
Common mistakes
- #NUM! probability is outside 0–1, or deg_freedom is less than 1.
Notes
- CHISQ.INV.RT replaces the older CHIINV function.
- Related functions: CHISQ.DIST.RT, CHISQ.TEST, CHISQ.INV.

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.