Syntax
CHIINV(probability, deg_freedom)
| Parameter | Description |
|---|---|
| probability | Parameter of the CHIINV function. |
| deg_freedom | Parameter of the CHIINV function. |
Examples
Critical value at 5% significance
Formula
=CHIINV(0.05, 3)
Returns ~7.815. The critical chi-squared value for a test with 3 df at the 5% significance level. Reject the null if your test statistic exceeds this.
1% significance threshold
Formula
=CHIINV(0.01, 5)
Returns ~15.086. A stricter critical value for 5 df at the 1% level.
Variance lower bound divisor
Formula
=CHIINV(0.025, 24)
Returns ~39.364. Used in the denominator when computing the lower bound of a confidence interval for variance.
Common Errors
#NUM!
Probability must be between 0 and 1 (exclusive). Degrees of freedom must be a positive integer.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Right-tail probability input
CHIINV takes the right-tail probability. For a 5% significance test, pass 0.05 directly — no need to subtract from 1.
Migrate to CHISQ.INV.RT
CHIINV is the compatibility function. CHISQ.INV.RT is the modern replacement with identical behavior.
Relationship to CHISQ.INV
CHIINV(p, df) = CHISQ.INV(1-p, df). They give the same chi-squared value but take complementary probability inputs.
Try CHIINV in Viztab
Import your data and use CHIINV with 370+ other formulas. No signup required.
Open Viztab