Excel functions / Statistics

CHISQ.DIST.RT function

The right tail of the chi-square distribution: the chance of a value greater than x. This is the p-value of a chi-square statistic.

Syntax

=CHISQ.DIST.RT(x, deg_freedom)

Arguments

When to use it

CHISQ.DIST.RT gives the chance of a chi-square value greater than x: the p-value of a chi-square statistic worked out by hand.

Examples

  1. p-value of 18.307 with 10 degrees of freedom

    ABCD
    1xdf
    218.307100.0500

    In D2: =CHISQ.DIST.RT(A2, B2) → 0.0500

    Try this example

Common mistakes

CHISQ.DIST.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 CHIDIST.

Try CHISQ.DIST.RT in the playground

Related functions