F.DIST.RT Function
Returns the right-tailed F distribution — an F-test p-value.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
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.DIST.RT returns the probability of an F value greater than x: the p-value for an F statistic, as shown in ANOVA and regression output.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The F statistic; can't be negative. |
| deg_freedom1 | Yes | Degrees of freedom of the numerator (top). |
| deg_freedom2 | Yes | Degrees of freedom of the denominator (bottom). |
Examples
Example 1 — p-value for an ANOVA result
An ANOVA comparing six groups gave F = 3.2 with 5 and 10 degrees of freedom.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | F statistic | 3.2 |
| 3 | df between | 5 |
| 4 | df within | 10 |
| 5 | p-value | 0.0554 |
p ≈ 0.055 — borderline, just above the usual 0.05 cut-off.
Common mistakes
- #NUM! x is negative, or either degrees of freedom is less than 1.
Notes

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.