The Excel F.DIST.RT function returns the right-tailed F probability distribution — the p-value side of an F-test, giving the area to the right of an F statistic.
Syntax
| Argument | Description | |
|---|---|---|
x | Required | The value at which to evaluate the function (the F statistic). Must be ≥ 0. |
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.DIST.RT returns the probability that an F statistic exceeds x — the area in the right tail. This is exactly the p-value reported by a one-tailed F-test for equal variances.
Because the two tails partition the whole distribution, F.DIST.RT(x,d1,d2) always equals 1 − F.DIST(x,d1,d2,TRUE). A small right-tail value (here about 1%) means the observed F statistic is large enough to reject the hypothesis of equal variances.
This is the modern replacement for the legacy FDIST function, which had the same right-tailed behavior but a name without the dot.
Tip: To find the critical F value for a chosen significance level (say 5%), pair this with F.INV.RT(0.05, d1, d2) — if your F statistic exceeds that cutoff, the right-tail p-value is below 0.05.
Try it: interactive demo
Enter an F value and the two degrees of freedom to build the right-tailed formula.
Practice workbook
Frequently asked questions
What does F.DIST.RT return?
x, i.e. the probability that an F statistic is greater than x. This is the p-value of a one-tailed F-test.How does F.DIST.RT relate to F.DIST?
F.DIST.RT(x,d1,d2) equals 1 − F.DIST(x,d1,d2,TRUE). F.DIST gives the left tail, F.DIST.RT gives the right tail.Is F.DIST.RT the same as the legacy FDIST?
F.DIST.RT (Excel 2010+) is the modern name; FDIST is kept in the Compatibility category for old workbooks.How do I interpret a small F.DIST.RT result?
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