F.INV.RT function
F.INV.RT returns the critical F value for a right-tail probability, which you compare against your test statistic. Pass 0.05, not 0.95, for the usual 5% test.
Example
Read it as a sentence: find the F value that leaves a 5% right-tail probability with 4 and 6 degrees of freedom, which gives 4.53367695.
A
B
C
D
1
4.53367695
2
3
Syntax
F.INV.RT(probability, deg_freedom1, deg_freedom2)
-
probability(required) - Right-tail probability, such as a 0.05 significance level.
-
deg_freedom1(required) - Numerator degrees of freedom.
-
deg_freedom2(required) - Denominator degrees of freedom.
Returns: The critical F value for the given right-tail probability.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=F.INV.RT(0.05,4,6) | 4.53367695 | Working example |
=F.INV.RT("0.05",4,6) | 4.53367695 | Text-number in first arg |
=F.INV.RT({0.05,0.05},4,6) | 4.53367695 | Array in first arg (lifts, spills) |
=F.INV.RT(1,4,6) | 0 | Probability 1 |
=F.INV.RT("abc",4,6) | #VALUE! | Non-numeric text in first arg |
=F.INV.RT(NA(),4,6) | #N/A | Error in first arg |
=F.INV.RT(0,4,6) | #NUM! | Probability 0 |
=F.INV.RT(0.05,0,6) | #NUM! | Df1 0 |
Watch out for
- Pass 0.05, not 0.95, for the usual 5% test.
Where it works
- Excel
- F.INV.RT arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .