Syntax
FDIST(x, deg_freedom1, deg_freedom2)
| Parameter | Description |
|---|---|
| x | Parameter of the FDIST function. |
| deg_freedom1 | Parameter of the FDIST function. |
| deg_freedom2 | Parameter of the FDIST function. |
Examples
ANOVA p-value
Formula
=FDIST(5.2, 3, 36)
Returns ~0.0044. The right-tail p-value for an F-statistic of 5.2 with 3 and 36 df is highly significant (p < 0.01).
Variance ratio test
Formula
=FDIST(2.5, 10, 10)
Returns ~0.0885. The p-value for comparing two variances with 10 observations each is about 8.9%, not significant at the 5% level.
Non-significant F-test
Formula
=FDIST(1.2, 4, 25)
Returns ~0.3351. An F-value of 1.2 with these df shows no significant difference between groups.
Common Errors
#NUM!
x must be non-negative and both degrees of freedom must be positive integers.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Use F.DIST.RT instead
FDIST is the compatibility function. F.DIST.RT is the modern replacement returning the same right-tailed probability.
Direct p-value for ANOVA
FDIST gives you the ANOVA p-value directly from the F-statistic. If FDIST(F, df1, df2) < 0.05, the group means are significantly different.
Order of df matters
The first df is the numerator (number of groups - 1) and the second is the denominator (total observations - number of groups). Reversing them gives wrong results.
Try FDIST in Viztab
Import your data and use FDIST with 370+ other formulas. No signup required.
Open Viztab