The Excel F.INV.RT function returns the inverse of the right-tailed F distribution — given a right-tail probability, it returns the critical F value, the cutoff used in F-tests and ANOVA.
Syntax
| Argument | Description | |
|---|---|---|
probability | Required | A right-tail probability associated with the F distribution, between 0 and 1. |
deg_freedom1 | Required | The numerator degrees of freedom (a positive integer). |
deg_freedom2 | Required | The denominator degrees of freedom (a positive integer). |
How to use it
F.INV.RT is the inverse of F.DIST.RT: you give it a right-tail probability (your significance level) and it returns the critical F value — the cutoff an F statistic must exceed to be significant.
This is the most natural function for hypothesis testing: pick a significance level α (say 0.05), and F.INV.RT(0.05, d1, d2) gives the critical value directly. If your computed F statistic is larger, you reject the null hypothesis at that level.
It mirrors F.INV across the tails: F.INV.RT(0.01, d1, d2) equals F.INV(0.99, d1, d2) because a 1% right tail is the same point as a 99% left tail.
Tip: F.INV.RT is the direct successor of the legacy FINV — both take a right-tail probability, so old FINV formulas translate to F.INV.RT with no change in arguments.
Try it: interactive demo
Enter a right-tail probability (significance level) and the two degrees of freedom.
Practice workbook
Frequently asked questions
What does F.INV.RT return?
F.DIST.RT.How is F.INV.RT different from F.INV?
F.INV.RT takes a right-tail probability while F.INV takes a left-tail probability. They are related by F.INV.RT(p,d1,d2) = F.INV(1−p,d1,d2).How do I find a critical F value for an F-test?
F.INV.RT(0.05, d1, d2) gives the 5% critical value. If your F statistic exceeds it, the result is significant at 5%.Is F.INV.RT the same as the old FINV?
FINV also takes a right-tail probability, so it is the direct predecessor of F.INV.RT (introduced in Excel 2010).Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class