Excel functions / Statistics

CHISQ.INV.RT function

The chi-square value with a given share of the distribution above it: the critical value of a chi-square test.

Syntax

=CHISQ.INV.RT(probability, deg_freedom)

Arguments

When to use it

CHISQ.INV.RT gives the chi-square value with a given share of the distribution above it: the critical value a chi-square statistic must pass.

Examples

  1. Critical value at 5% with 10 degrees of freedom

    ABCD
    1alphadf
    20.051018.307

    In D2: =CHISQ.INV.RT(A2, B2) → 18.307

    Try this example

Common mistakes

CHISQ.INV.RT in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Also written as CHIINV.

Try CHISQ.INV.RT in the playground

Related functions