Excel functions / Statistics

F.INV function

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

Syntax

=F.INV(probability, deg_freedom1, deg_freedom2)

Arguments

When to use it

F.INV gives the F value below which a share of the F-distribution falls.

Examples

  1. The 1st percentile with 6 and 4 degrees of freedom

    ABCDE
    1pdf1df2
    20.01640.1093

    In E2: =F.INV(A2, B2, C2) → 0.1093

    Try this example

Common mistakes

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

Related functions