Buzz
This article introduces you to the F.DIST.RT function - one of the statistical functions widely used in Excel.
Description: Returns the right-tailed F probability distribution for 2 datasets. Supported since Excel 2010.
Syntax: F.DIST(x,deg_freedom1,deg_freedom2)
In which:
- x: The value of the function, is a required parameter.
- deg_freedom1: Degree of freedom in the numerator, is a required parameter.
- deg_freedom2: Degree of freedom in the denominator, is a required parameter.
Note:
- If any parameter is not a numeric value -> the function returns an error value #VALUE!
- If x < 0 -> the function returns an error value #NUM!
- If deg_freedom1, deg_freedom2 are not integers -> they are truncated to integers.
- If deg_freedom1 < 1 or deg_freedom2 < 1 -> the function returns an error value #NUM!
- The F.DIST.RT function is computed as F.DIST.RT = P (F > x) where F is the random variable.
Example:
Calculate the right-tailed F distribution probability based on the data table below:
- In the cell where calculation is needed, input the formula: =F.DIST.RT(D6,D7,D8)
- Press Enter -> the F distribution probability is:
- If the function value is less than 0 -> the function returns an error value #NUM!
- If the degrees of freedom in the numerator and denominator are less than 1 -> the function returns an error value #NUM!
Here is the guide and some specific examples when using the F.DIST.RT function in Excel.
Wishing you all success!
