Syntax
F.INV.RT(probability, deg_freedom1, deg_freedom2)
| Parameter | Description |
|---|---|
| probability | Parameter of the F.INV.RT function. |
| deg_freedom1 | Parameter of the F.INV.RT function. |
| deg_freedom2 | Parameter of the F.INV.RT function. |
Examples
ANOVA critical value
Formula
=F.INV.RT(0.05, 2, 27)
Returns ~3.354. In a one-way ANOVA comparing 3 groups with 30 total observations, reject the null hypothesis if the F-statistic exceeds 3.35.
Regression model significance
Formula
=F.INV.RT(0.01, 4, 95)
Returns ~3.525. For a regression with 4 predictors and 100 data points, the model's F-statistic must exceed 3.53 to be significant at the 1% level.
Comparing two variances
Formula
=F.INV.RT(0.05, 24, 19)
Returns ~2.106. The critical F-value for testing whether two groups' variances differ, with 25 and 20 observations.
Common Errors
#NUM!
Probability must be between 0 and 1 (exclusive). Both degrees of freedom must be at least 1.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Pass alpha directly
For a 5% significance test, simply use F.INV.RT(0.05, df1, df2). No need to subtract from 1.
Decision rule for ANOVA
If your calculated F-statistic > F.INV.RT(alpha, df1, df2), reject the null hypothesis that all group means are equal.
Degrees of freedom for ANOVA
For k groups and N total observations: df1 = k-1 (between groups), df2 = N-k (within groups). Double-check these before looking up the critical value.
Try F.INV.RT in Viztab
Import your data and use F.INV.RT with 370+ other formulas. No signup required.
Open Viztab