F.INV
Returns the inverse of the F probability distribution.
StatisticalStatistics & Analysis
What it does
Legacy inverse F distribution function.
Syntax
FINV(probability, deg_freedom1, deg_freedom2)
Arguments
probability(number) — Probability.deg_freedom1(number) — Numerator df.deg_freedom2(number) — Denominator df.
Examples
Legacy Inverse F
Calculate inverse.
FORMULA
=FINV(0.01, 6, 4)
RESULT
15.2
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Prob | df1 | df2 |
| 2 | 0.01 | 6 | 4 |