Excel functions / Statistics

F.DIST.RT function

The right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.

Syntax

=F.DIST.RT(x, deg_freedom1, deg_freedom2)

Arguments

When to use it

F.DIST.RT gives the chance of an F ratio greater than x: the p-value of an F statistic, as in an analysis of variance.

Examples

  1. p-value of 15.2069 with 6 and 4 degrees of freedom

    ABCDE
    1xdf1df2
    215.2069640.010

    In E2: =F.DIST.RT(A2, B2, C2) → 0.010

    Try this example

Common mistakes

F.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 FDIST.

Try F.DIST.RT in the playground

Related functions