CHISQ.INV function
CHISQ.INV turns a left-tail probability into the matching chi-squared value. It is useful for building confidence intervals around a variance, and it works from the left tail only.
Example
Read it as a sentence: find the chi-square value for the left-tail probability in D1 (empty, so 0) with 4 degrees of freedom.
Excel shows 0
D
1
Data
Syntax
CHISQ.INV(probability, deg_freedom)
-
probability(required) - Left-tail probability between 0 and 1.
-
deg_freedom(required) - Degrees of freedom.
Returns: The chi-squared value with the given left-tail probability.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=CHISQ.INV(0.95,4) | 9.487729037 | Working example |
=CHISQ.INV("0.95",4) | 9.487729037 | Text-number in first arg |
=CHISQ.INV({0.95,0.95},4) | 9.487729037 | Array in first arg (lifts, spills) |
=CHISQ.INV(0,4) | 0 | Probability 0 |
=CHISQ.INV(Data!D1,4) | 0 | Blank cell as first arg |
=CHISQ.INV("abc",4) | #VALUE! | Non-numeric text in first arg |
=CHISQ.INV(NA(),4) | #N/A | Error in first arg |
=CHISQ.INV(1,4) | #NUM! | Probability 1 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Left tail: 0.95 here matches CHISQ.INV.RT with 0.05.
- Probability must be between 0 and 1.
Where it works
- Excel
- CHISQ.INV arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .