Excel functions / Statistics

F.DIST function

The F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.

Syntax

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

Arguments

When to use it

F.DIST gives the chance of a ratio of two variances of x or less (with TRUE) in the F-distribution, or the height of its curve.

Examples

  1. Below 15.2069 with 6 and 4 degrees of freedom

    ABCDE
    1xdf1df2
    215.2069640.99

    In E2: =F.DIST(A2, B2, C2, TRUE) → 0.99

    Try this example

Common mistakes

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

Related functions