In this article
CHISQ.INV.RT gives the critical value for a chi-square test: if your statistic is bigger, the result is significant.
Advertisement
Syntax
=CHISQ.INV.RT(probability, deg_freedom)| Argument | What it means |
|---|---|
probability |
Significance level, e.g. 0.05 |
deg_freedom |
df |
Examples
Example 1
=ROUND(CHISQ.INV.RT(A2,B2),3)Result: 3.841. See the worked example table below for more cases.
CHISQ.INV.RT in practice
Where you will use it
- Critical value for a 5% test
- Building a pass/fail rule in a QC sheet
- Teaching
Worked example
| alpha | df | Formula | Result |
|---|---|---|---|
| 0.05 | 1 | =ROUND(CHISQ.INV.RT(A2,B2),3) | 3.841 |
| 0.05 | 3 | =ROUND(CHISQ.INV.RT(A3,B3),3) | 7.815 |
| 0.01 | 3 | =ROUND(CHISQ.INV.RT(A4,B4),3) | 11.345 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Using 95 instead of 0.05 | Enter the significance level as 0.05 |
| Wrong df | (rows-1) x (columns-1) for tables |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong