Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
CHISQ.INV
Returns the inverse of the left-tailed chi-squared distribution.
Rarely usedDifficulty 1500 · AdvancedUsage rank #388 of 520
When to use it
The chi-squared value at a given left-tail probability.
The shape of it
- Syntax
=CHISQ.INV(probability, deg_freedom)
Worked examples
Critical value
=CHISQ.INV(0.95,1) → 3.841458821
The 95th percentile on 1 degree of freedom.
Median
=CHISQ.INV(0.5,2) → 1.386294361
The median with 2 degrees of freedom: 2 × LN(2).
Ten degrees of freedom
=CHISQ.INV(0.99,10) → 23.20925116
99th percentile on 10 degrees of freedom.
Worth knowing
- For a critical value at significance alpha use CHISQ.INV(1-alpha,df) or CHISQ.INV.RT(alpha,df).
- Confidence interval for a variance uses both tails.
- Replaces the left-tail use of CHIINV.
Where it goes wrong
- #NUM! for probability outside 0 to 1 or df below 1.
- Iterative; very large df can be slow.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.