The `F.INV.RT` function in Excel is used to calculate the inverse of the right-tailed F probability distribution. This function is useful when you want to determine the value at which the probability of the F-distribution equals a given probability. The right-tailed F-distribution is often used in analysis of variance (ANOVA) tests and regression analysis.
Here’s the syntax for the `F.INV.RT` function:
F.INV.RT(probability, deg_freedom1, deg_freedom2)
- probability: This is the probability associated with the F cumulative distribution. It is a required parameter and should be a numeric value between 0 and 1, exclusive.
- deg_freedom1: This is the numerator degrees of freedom, a required parameter. It should be a positive integer.
- deg_freedom2: This is the denominator degrees of freedom, a required parameter. It should also be a positive integer.
Example
Suppose you want to find the F-value corresponding to a 0.05 probability with 5 numerator degrees of freedom and 10 denominator degrees of freedom.
=F.INV.RT(0.05, 5, 10)
- Click on a cell where you want to display the result.
- Enter the formula:
- Press Enter.
This will return the F-value associated with the 0.05 probability for the given degrees of freedom.
Additional Notes
- If any argument is non-numeric, the `F.INV.RT` function will return a `#VALUE!` error.
- If `probability` is less than or equal to 0, or greater than or equal to 1, `F.INV.RT` will return a `#NUM!` error.
- If `deg_freedom1` or `deg_freedom2` are not integers, they are truncated.
- If either `deg_freedom1` or `deg_freedom2` are less than 1, the function returns a `#NUM!` error.
This function is especially helpful when performing statistical analyses where understanding the variance between datasets is crucial.
Unlock Your Potential
Excel
Access
Power BI
