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
probability: The share in the right tail, such as 0.05.deg_freedom1: The degrees of freedom of the numerator.deg_freedom2: The degrees of freedom of the denominator.
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
Critical F at 1% with 6 and 4 degrees of freedom
A B C D E 1 alpha df1 df2 2 0.01 6 4 15.207 In E2:
=F.INV.RT(A2, B2, C2)→ 15.207
Common mistakes
- Order. Numerator degrees of freedom first, then the denominator's.
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.
- Czech: F.INV.RT
- Danish: F.INV.RT
- Dutch: F.INV.RECHTS
- Finnish: F.KÄÄNT.OH
- French: INVERSE.LOI.F.DROITE
- German: F.INV.RE
- Hungarian: F.INVERZ.JOBB
- Italian: INV.F.DS
- Norwegian: F.INV.H
- Polish: ROZKŁ.F.ODWR.PS
- Portuguese (Brazil): INV.F.CD
- Portuguese (Portugal): INV.F.DIR
- Russian: F.ОБР.ПХ
- Spanish: INV.F.CD
- Swedish: F.INV.RT
- Turkish: F.TERS.SAĞK
Also written as FINV.
Try F.INV.RT in the playground