Buzz
This article introduces you to the F.INV.RT function, one of the commonly used statistical functions in Excel.
Description: Returns the inverse value of the right-tailed F probability distribution. Supported since Excel 2010.
Syntax: F.INV.RT(probability,deg_freedom1,deg_freedom2)
Where:
- probability: Probability associated with the F cumulative distribution, a mandatory parameter.
- deg_freedom1: Degrees of freedom in the numerator, a mandatory parameter.
- deg_freedom2: Degrees of freedom in the denominator, a mandatory parameter.
Note:
- If any parameter is not a numerical value -> the function returns an error value #VALUE!
- If probability < 0 or probability > 1 -> 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!
Example:
Calculate the inverse right-tailed value of the F probability distribution based on the data in the table below:
- In the cell where you want to calculate, enter the formula : =F.INV.RT(D6,D7,D8)
- Press Enter -> the inverse right-tailed value of the F probability distribution is:
- If the probability associated with the cumulative F distribution > 1 -> the function returns an error value #NUM!
- If the degrees of freedom in the numerator and denominator are both less than 1 -> the function returns an error value #NUM!
Above is the guide and some specific examples when using the F.INV.RT function in Excel.
Wishing you all success!
