Compatibility - FDIST Function

The FDIST function replaces the F.DIST.RT function in Excel 2010.

Description

The function returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. You can use this function to determine whether two data sets have different degrees of diversity.

Syntax

FDIST(x,deg_freedom1,deg_freedom2)

Arguments

Argument Description Required/ Optional
X The value at which to evaluate the function. Required
Deg_freedom1 The numerator degrees of freedom. Required
Deg_freedom2 The denominator degrees of freedom. Required

Notes

  • FDIST is calculated as

    $$FDIST=P (F>x)$$

    Where F is a random variable that has an F distribution with deg_freedom1 and deg_freedom2 degrees of freedom.

  • If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.

  • If any argument is nonnumeric, FDIST returns the #VALUE! error value.

  • If x is negative, FDIST returns the #NUM! error value.

  • If deg_freedom1 < 1 or deg_freedom1 ≥ 10^10, FDIST returns the #NUM! error value.

  • If deg_freedom2 < 1 or deg_freedom2 ≥ 10^10, FDIST returns the #NUM! error value.

Example

FDIST Function
advanced_excel_compatibility_functions.htm
Advertisements