Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .