Excel functions / Statistics

CHISQ.INV function

The value below which a given share of the chi-square distribution falls.

Syntax

=CHISQ.INV(probability, deg_freedom)

Arguments

When to use it

CHISQ.INV gives the chi-square value below which a share of the distribution falls.

Examples

  1. The 93rd percentile with 1 degree of freedom

    ABCD
    1pdf
    20.9313.283

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

    Try this example

Common mistakes

CHISQ.INV 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

Try CHISQ.INV in the playground

Related functions