Statistical - F.DIST.RT Function

Description

The F.DIST.RT 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

F.DIST.RT(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

  • F.DIST.RT is calculated as

    F.DIST.RT = 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, F.DIST.RT returns the #VALUE! error value.

  • If x is negative, F.DIST.RT returns the #NUM! error value.

  • If deg_freedom1 < 1 F.DIST.RT returns the #NUM! error value.

  • If x is negative, F.DIST.RT returns the #NUM! error value.

  • If deg_freedom2 < 1 F.DIST.RT returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

F.Dist.RT Function
advanced_excel_statistical_functions.htm
Advertisements