Syntax
F.INV(probability, deg_freedom1, deg_freedom2)
| Parameter | Description |
|---|---|
| probability | Parameter of the F.INV function. |
| deg_freedom1 | Parameter of the F.INV function. |
| deg_freedom2 | Parameter of the F.INV function. |
Examples
95th percentile F-value
Formula
=F.INV(0.95, 3, 20)
Returns ~3.098. 95% of the F-distribution with 3 and 20 df falls below this value.
Lower bound for variance ratio CI
Formula
=F.INV(0.025, 14, 19)
Returns ~0.3505. Used as the lower multiplier when constructing a confidence interval for the ratio of two variances.
Median of F-distribution
Formula
=F.INV(0.5, 5, 10)
Returns ~0.9319. The median F-value with 5 and 10 df is slightly less than 1.
Common Errors
#NUM!
Probability must be between 0 and 1 (inclusive). Both degrees of freedom must be at least 1.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Left-tailed vs right-tailed
F.INV returns the left-tail inverse. For finding critical values for ANOVA and F-tests (which reject in the right tail), use F.INV.RT instead.
Reciprocal relationship
F.INV(p, df1, df2) = 1 / F.INV.RT(p, df2, df1). You can convert between left and right tail inverses by taking the reciprocal and swapping df.
Variance ratio CI
To construct a CI for the ratio of two variances: lower = (s1^2/s2^2) * F.INV(alpha/2, n2-1, n1-1), upper = (s1^2/s2^2) * F.INV(1-alpha/2, n2-1, n1-1).
Try F.INV in Viztab
Import your data and use F.INV with 370+ other formulas. No signup required.
Open Viztab