F.DIST.RT

Formulas / F.DIST.RT
Determine if two datasets have different degrees of diversity.
F.DIST.RT(x,deg_freedom1,deg_freedom2)
  • x - required argument to evaluate the function on
  • deg_freedom1 - required numerator degrees of freedom
  • deg_freedom2 - required argument

Examples

  • =F.DIST.RT(A2,A3,A4)

    If you wanted to know the F probability distribution for three values, A2, A3, and A4, then you would use the preceding function.

Summary

The F.DIST.RT function calculates the right-tailed F probability distribution given the value to evaluate and the numerator and denominator degrees of freedom of the F probability distribution.

  • The F.DIST.RT function returns the F probability distribution and determines whether two data sets have different degrees of similarity.
  • The F.DIST.RT function takes three arguments: X, Deg_freedom1, and Deg_freedom2; all of which are required.


Frequently Asked Questions

What is the F.DIST.RT function?
The F.DIST.RT function calculates the right-tailed F probability distribution. This probability distribution is used to calculate the degree of diversity in two separate data sets.
What does the F probability distribution calculate?
The F probability distribution is used to determine if two data sets have different levels of diversity.
What errors can the F.DIST.RT function return?
  • The F.DIST.RT function returns the #VALUE! error if any of its arguments are not numbers.
  • The F.DIST.RT returns a #NUM! error if x is negative.
  • The F.DIST.RT returns a #NUM! error if deg_freedom_1 or deg_freedom_2 is less than F.DIST.RT.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.