Syntax
F.DIST.RT(x, deg_freedom1, deg_freedom2)
| Parameter | Description |
|---|---|
| x | Parameter of the F.DIST.RT function. |
| deg_freedom1 | Parameter of the F.DIST.RT function. |
| deg_freedom2 | Parameter of the F.DIST.RT function. |
Examples
One-way ANOVA p-value
Formula
=F.DIST.RT(4.07, 2, 27)
Returns ~0.0285. With an F-value of 4.07, 2 groups, and 27 within-group df, the ANOVA result is significant at the 5% level.
Regression F-test
Formula
=F.DIST.RT(15.3, 4, 95)
Returns ~0.0000004. In a regression with 4 predictors and 100 observations, an F of 15.3 is highly significant — the model explains significant variance.
Variance equality check
Formula
=F.DIST.RT(1.8, 14, 19)
Returns ~0.1114. The two samples do not have significantly different variances at the 5% level.
Common Errors
#NUM!
x must be non-negative and both degrees of freedom must be at least 1.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Standard ANOVA output
Most ANOVA tables report the p-value from F.DIST.RT. If you calculate the F-statistic manually, plug it into this function to get the p-value.
Numerator df = groups - 1
In one-way ANOVA: df1 = k-1 (number of groups minus 1), df2 = N-k (total observations minus number of groups).
Larger F = more evidence
Larger F-statistics produce smaller p-values. An F close to 1 means between-group variance is similar to within-group variance — no significant effect.
Try F.DIST.RT in Viztab
Import your data and use F.DIST.RT with 370+ other formulas. No signup required.
Open Viztab