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
probability: A probability, between 0 and 1.deg_freedom1: The degrees of freedom of the numerator.deg_freedom2: The degrees of freedom of the denominator.
When to use it
F.INV gives the F value below which a share of the F-distribution falls.
Examples
The 1st percentile with 6 and 4 degrees of freedom
A B C D E 1 p df1 df2 2 0.01 6 4 0.1093 In E2:
=F.INV(A2, B2, C2)→ 0.1093
Common mistakes
- Critical values. For an upper critical value, F.INV.RT is the one.
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.
- Czech: F.INV
- Danish: F.INV
- Dutch: F.INV
- Finnish: F.KÄÄNT
- French: INVERSE.LOI.F.N
- German: F.INV
- Hungarian: F.INVERZ
- Italian: INVF
- Norwegian: F.INV
- Polish: ROZKŁ.F.ODWR
- Portuguese (Brazil): INV.F
- Portuguese (Portugal): INV.F
- Russian: F.ОБР
- Spanish: INV.F
- Swedish: F.INV
- Turkish: F.TERS