ExcelFlux

CHIINV function

the inverse of the one-tailed probability of the chi-squared distribution.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find the chi-square cutoff associated with an upper-tail probability.

A worked example from the workbook

RowA
6Input
70.1
80.5
90.9
Record 1
=CHIINV(A7,4)

Illustrative output7.77944034

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

Find the chi-square cutoff associated with an upper-tail probability.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 0.1
8 0.5
9 0.9
Trial Expression Sample output
Record 1 =CHIINV(A7,4) 7.77944034
Record 2 =CHIINV(A8,4) 3.35669398
Record 3 =CHIINV(A9,4) 1.063623217
Microsoft Excel reference