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

The FDIST function calculates the F probability of the right-tailed distribution for two tests. This function is outdated and is replaced with the F.DIST and F.DIST.RT function which was introduced in Excel 2010.

Formula in cell C7:

=FDIST(C3,C4,C5)

Excel Function Syntax

FDIST(x, deg_freedom1, deg_freedom2)

Arguments

x Required.
deg_freedom1 Required. Degrees of freedom (numerator).
deg_freedom2 Required. Degrees of freedom (denominator).

Comments

The FDIST function returns

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

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