Excel functions / Statistics

CHISQ.DIST function

The chi-square distribution: the chance of a value of x or less, or the height of the curve at x.

Syntax

=CHISQ.DIST(x, deg_freedom, cumulative)

Arguments

When to use it

CHISQ.DIST gives the chance of a value of x or less in a chi-square distribution (with TRUE), or the height of its curve.

Examples

  1. Below 0.5 with 1 degree of freedom

    ABCD
    1xdf
    20.510.5205

    In D2: =CHISQ.DIST(A2, B2, TRUE) → 0.5205

    Try this example

Common mistakes

CHISQ.DIST 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.DIST in the playground

Related functions