Formualizer Docs

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

ArgumentTypeRequiredDefault
probabilitynumberRequired—
deg_freedomnumberRequired—

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_freedom is truncated to an integer.

Error cases

  • Returns #NUM! when probability is outside [0, 1] or deg_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?.

Implementation

Engine source

On this page