CHISQ.INV Function

Returns the inverse of the left-tailed chi-square distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice CHISQ.INV 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 returns the value with the given probability below it.

Syntax

=CHISQ.INV(probability, deg_freedom) Explain

Arguments

ArgumentRequired?What it does
probabilityYesThe left-tail probability, 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 — The 95th percentile

4 degrees of freedom.

B3fx=CHISQ.INV(0.95,B2)
AB
1MeasureValue
2Degrees of freedom4
395% below9.4877
4Same, right tail9.4877
=CHISQ.INV(0.95,B2) Explain

CHISQ.INV(0.95, …) equals CHISQ.INV.RT(0.05, …) — two ways to find the same 5% cut-off.

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.