Functions
CHISQ.INV
Chi-squared inverse CDF
Try it
When to use it
When should I use CHISQ.INV?
Use CHISQ.INV to find the chi-squared value whose left-tail CDF equals p — the inverse of CHISQ.DIST with cumulative=TRUE, used to compute left-tail critical values for confidence intervals or variance tests.
Used in
Syntax
CHISQ.INV(p,df)Examples
=CHISQ.INV(0.95,4) // => 9.487729036781152