F.DIST Function

Returns the left-tailed F distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice F.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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 with cumulative TRUE returns the probability of an F value up to x. Test p-values usually use the right tail, F.DIST.RT.

Syntax

=F.DIST(x, deg_freedom1, deg_freedom2, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe F value; can't be negative.
deg_freedom1YesDegrees of freedom of the numerator (top).
deg_freedom2YesDegrees of freedom of the denominator (bottom).
cumulativeYesTRUE for the cumulative (left-tail) probability, FALSE for the density.

Examples

Example 1 — Left tail and density

An F value of 2 with 5 and 10 degrees of freedom.

B5fx=F.DIST(B2,B3,B4,TRUE)
AB
1MeasureValue
2F2
3df15
4df210
5Left tail0.8358
6Density0.1620
=F.DIST(B2,B3,B4,TRUE) Explain

Common mistakes

  • #NUM! x is negative, or either degrees of freedom is less than 1.

Notes

Kyle Stott

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.