F.DIST function
F.DIST returns the left-tailed F distribution at a value, used when comparing variances or running ANOVA. For p-values, use F.DIST.RT, and keep the two degrees of freedom in order.
Example
Read it as a sentence: find the cumulative F distribution at 2 with 4 and 6 degrees of freedom, which gives 0.786339025.
A
B
C
D
1
0.786339025
2
3
Syntax
F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
-
x(required) - Value at which to evaluate; not negative.
-
deg_freedom1(required) - Numerator degrees of freedom.
-
deg_freedom2(required) - Denominator degrees of freedom.
-
cumulative(required) - TRUE for cumulative left-tail, FALSE for density.
Returns: The left-tailed F distribution value at x.
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.DIST(2,4,6,TRUE) | 0.786339025 | Working example |
=F.DIST(2,4,6,FALSE) | 0.154221455 | Other cumulative flag |
=F.DIST(2,4,6,0) | 0.154221455 | Cumulative as 0 |
=F.DIST("2",4,6,TRUE) | 0.786339025 | Text-number in first arg |
=F.DIST({2,2},4,6,TRUE) | 0.786339025 | Array in first arg (lifts, spills) |
=F.DIST(2,4.9,6.9,TRUE) | 0.786339025 | Fractional df truncated |
=F.DIST("abc",4,6,TRUE) | #VALUE! | Non-numeric text in first arg |
=F.DIST(NA(),4,6,TRUE) | #N/A | Error in first arg |
Watch out for
- Left tail; for p-values use F.DIST.RT.
- Swapping the two degrees of freedom gives a different answer.
Where it works
- Excel
- F.DIST 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 .