F.DIST.RT
Formulas / F.DIST.RTDetermine 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.
Need help with Formulas?
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.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV