CHISQ.INV.RT function
CHISQ.INV.RT gives the critical chi-squared value to compare a test statistic against at a chosen significance level. Pass the significance level directly, such as 0.05, not 0.95.
Example
Read it as a sentence: find the chi-square value with a right-tail probability of 0.05 and 4 degrees of freedom, which gives 9.487729037.
A
B
C
D
1
9.487729037
2
3
Syntax
CHISQ.INV.RT(probability, deg_freedom)
-
probability(required) - Right-tail probability, e.g. a significance level like 0.05.
-
deg_freedom(required) - Degrees of freedom.
Returns: The chi-squared critical value for the given right-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.RT(0.05,4) | 9.487729037 | Working example |
=CHISQ.INV.RT("0.05",4) | 9.487729037 | Text-number in first arg |
=CHISQ.INV.RT({0.05,0.05},4) | 9.487729037 | Array in first arg (lifts, spills) |
=CHISQ.INV.RT(1,4) | 0 | Probability 1 |
=CHISQ.INV.RT("abc",4) | #VALUE! | Non-numeric text in first arg |
=CHISQ.INV.RT(NA(),4) | #N/A | Error in first arg |
=CHISQ.INV.RT(0,4) | #NUM! | Probability 0 |
=CHISQ.INV.RT(0.05,0) | #NUM! | Df 0 |
Watch out for
- Pass the significance level directly (0.05), not 0.95.
- Calculated iteratively and can return #N/A if it fails to converge.
Where it works
- Excel
- CHISQ.INV.RT 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 .