Excel functions / Statistics

F.INV.RT function

The F value with a given share of the distribution above it: the critical value of an F-test.

Syntax

=F.INV.RT(probability, deg_freedom1, deg_freedom2)

Arguments

When to use it

F.INV.RT gives the F value with a given share of the distribution above it: the critical value an F statistic must pass.

Examples

  1. Critical F at 1% with 6 and 4 degrees of freedom

    ABCDE
    1alphadf1df2
    20.016415.207

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

    Try this example

Common mistakes

F.INV.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 FINV.

Try F.INV.RT in the playground

Related functions