Syntax
CHISQ.INV.RT(probability, deg_freedom)
| Parameter | Description |
|---|---|
| probability | Parameter of the CHISQ.INV.RT function. |
| deg_freedom | Parameter of the CHISQ.INV.RT function. |
Examples
Critical value for 2x2 table
Formula
=CHISQ.INV.RT(0.05, 1)
Returns ~3.841. The critical chi-squared value for a 2x2 contingency table (1 df) at the 5% significance level.
10% significance with 10 df
Formula
=CHISQ.INV.RT(0.10, 10)
Returns ~15.987. The critical value for a more lenient significance threshold with 10 degrees of freedom.
Strict threshold for large table
Formula
=CHISQ.INV.RT(0.001, 8)
Returns ~26.125. A very strict critical value for an analysis with 8 df at the 0.1% significance level.
Common Errors
#NUM!
Probability must be between 0 and 1 (exclusive). Degrees of freedom must be at least 1.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Direct significance level input
Pass your alpha level (e.g., 0.05) directly. The function returns the value your test statistic must exceed to be significant.
Common critical values
Memorize a few: CHISQ.INV.RT(0.05, 1) = 3.84, CHISQ.INV.RT(0.05, 2) = 5.99, CHISQ.INV.RT(0.05, 3) = 7.81. These cover many practical tests.
Decision rule
If your calculated chi-squared statistic > CHISQ.INV.RT(alpha, df), reject the null hypothesis. Otherwise, fail to reject.
Try CHISQ.INV.RT in Viztab
Import your data and use CHISQ.INV.RT with 370+ other formulas. No signup required.
Open Viztab