F.INV Function

Returns the inverse of the left-tailed F distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice F.INV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

The F distribution describes the ratio of two variances. It's used to test whether two groups vary by different amounts and in ANOVA and regression. It has two degrees of freedom: one for the top of the ratio, one for the bottom.

F.INV returns the F value with the given probability below it.

Syntax

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

Arguments

ArgumentRequired?What it does
probabilityYesThe left-tail probability, from 0 to 1.
deg_freedom1YesDegrees of freedom of the numerator (top).
deg_freedom2YesDegrees of freedom of the denominator (bottom).

Examples

Example 1 — The 95th percentile

5 and 10 degrees of freedom.

B4fx=F.INV(0.95,B2,B3)
AB
1MeasureValue
2df15
3df210
495% below3.3258
=F.INV(0.95,B2,B3) Explain

The same as F.INV.RT(0.05,5,10).

Common mistakes

  • #NUM! probability is outside 0–1, or either degrees of freedom is less than 1.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.