CHIINV
Returns the inverse of the right-tailed chi-squared probability (legacy name).
CHIINV(probability, deg_freedom) is the x with CHIDIST(x, deg_freedom) = probability, the same as CHISQ.INV.RT.
The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=CHIINV(probability, deg_freedom)
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
probability | number | Required | — |
deg_freedom | number | Required | — |
How it works
Maps to CHISQ.INV.RT with the same two arguments. Inverts the upper chi-squared tail for positive degrees of freedom and a probability greater than zero and at most one.
Remarks
deg_freedomis truncated to an integer.
Error cases
- Returns
#NUM!whenprobabilityis outside[0, 1]ordeg_freedom < 1.
Examples
Find the legacy upper-tail chi-square cutoff at probability one half.
Formula =CHIINV(0.5,3)
Expected result 2.36597388437534
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Leave a right-tail area of one quarter with ten degrees of freedom.
Formula =CHIINV(0.25,10)
Expected result 12.5488613968894
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Use one degree of freedom with equal probability on either side.
Formula =CHIINV(0.5,1)
Expected result 0.454936423119572
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
A probability above one is invalid.
Formula =CHIINV(1.1,3)
Expected result #NUM!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Find the chi-square threshold leaving about 5% of the area in the upper tail with ten degrees of freedom.
Formula =CHIINV(0.050001,10)
Expected result 18.3069734569611
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.