F.INV.RT Function

Returns the inverse of the right-tailed F distribution — the critical F value.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice F.INV.RT 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.RT returns the F value with the given probability above it: the critical value an F statistic must beat to be significant.

Syntax

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

Arguments

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

Examples

Example 1 — Critical F at the 5% level

5 and 10 degrees of freedom.

B5fx=F.INV.RT(0.05,B3,B4)
AB
1MeasureValue
2F statistic3.2
3df15
4df210
5Critical (5%)3.3258
=F.INV.RT(0.05,B3,B4) Explain

The statistic (3.2) falls just short of the critical value (3.33), matching the p-value of 0.055.

Common mistakes

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

Notes

  • F.INV.RT replaces the older FINV function.
  • Related functions: F.DIST.RT, F.INV.
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.