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

Want to practice CHISQ.INV.RT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=CHISQ.INV.RT(probability, deg_freedom) Explain

Arguments

ArgumentRequired?What it does
probabilityYesThe right-tail probability (significance level), from 0 to 1.
deg_freedomYesDegrees 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.

E2fx=SUMPRODUCT((B2:B6-C2:C6)^2/C2:C6)
ABCDE
1DayTicketsExpectedMeasureResult
2Mon2824Statistic3.75
3Tue2224Critical (5%)9.4877
4Wed1924
5Thu2124
6Fri3024
=SUMPRODUCT((B2:B6-C2:C6)^2/C2:C6) Explain

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

Kyle Stott

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.