Author: Oscar Cronquist Article last updated on October 12, 2018

The F.DIST function calculates the F probability for two tests. This function was introduced in Excel 2010 and has replaced the FDIST function.

Formula in cell C7:

=F.DIST(C3,C4,C5,C6)

Excel Function Syntax

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

Arguments

x Required.
deg_freedom1 Required. Degrees of freedom (numerator).
deg_freedom2 Required. Degrees of freedom (denominator).
cumulative Required. A boolean value.
TRUE - Cumulative distribution function.
FALSE - Probability density function.

Comments

The F.DIST function returns

  • #VALUE! error value if any argument is non-numeric.
  • #NUM! error value if:
    • x < 0 (zero)
    • deg_freedom1 < 1
    • deg_freedom2 < 1

deg_freedom1 and deg_freedom2 will be converted into integers if they are not.