Syntax
FINV(probability, deg_freedom1, deg_freedom2)
| Parameter | Description |
|---|---|
| probability | Parameter of the FINV function. |
| deg_freedom1 | Parameter of the FINV function. |
| deg_freedom2 | Parameter of the FINV function. |
Examples
ANOVA critical value at 5%
Formula
=FINV(0.05, 3, 36)
Returns ~2.866. In a one-way ANOVA comparing 4 groups with 40 total observations, reject the null if your F-statistic exceeds 2.87.
1% critical value
Formula
=FINV(0.01, 2, 60)
Returns ~4.977. A stricter threshold for 3 groups with a large within-group sample.
Equal variance test threshold
Formula
=FINV(0.025, 9, 9)
Returns ~4.026. The critical F-value for a two-tailed variance equality test at the 5% level with 10 observations per group.
Common Errors
#NUM!
Probability must be between 0 and 1 (exclusive). Both degrees of freedom must be positive integers.
#VALUE!
Occurs when arguments are non-numeric.
Tips
Use F.INV.RT instead
FINV is the compatibility function. F.INV.RT is the modern replacement with identical behavior.
Right-tail probability input
Pass your significance level directly (e.g., 0.05 for a 5% test). The returned value is the critical F-value for the right tail.
FINV(p, df1, df2) = F.INV(1-p, df1, df2)
FINV takes the right-tail probability while F.INV takes the left-tail (cumulative) probability. They are complementary.
Try FINV in Viztab
Import your data and use FINV with 370+ other formulas. No signup required.
Open Viztab