How to use F.DIST.RT Function in Excel

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)

The F.DIST.RT function syntax has the following arguments:

1. X (required argument) – This is the value at which we evaluate the function.
2. Deg_freedom1 (required argument) – This is an integer specifying the numerator degrees of freedom.
3. Deg_freedom2 (required argument) – An integer specifying the denominator degrees of freedom.

Example: Let’s look at some Excel F.DIST.RT function examples and explore how to use the F.DIST.RT function as a worksheet function in Microsoft Excel:

Syntax:  =F.DIST.RT(B1,B2,B3)

Result: 0.062956616

Note:

• 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 or deg_freedom2 is not an integer, it is truncated.
• If deg_freedom1 < 1 F.DIST.RT returns the #NUM! error value.
• If deg_freedom2 < 1 F.DIST.RT returns the #NUM! error value.

• 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.