F.INV (Probability, DegreesOfFreedom1, DegreesOfFreedom2) F.INV (Probability; DegreesOfFreedom1; DegreesOfFreedom2)
Probability
Number Number
The probability, which must be greater than 0 and at most 1.
DegreesOfFreedom1
Number Number
The numerator degrees of freedom.
DegreesOfFreedom2
Number Number
The denominator degrees of freedom.
Returns
Number Number
The value at which the cumulative F distribution equals the given probability.
Returns the inverse of the cumulative F.DIST function. Given a probability, this function returns the value at which the cumulative F distribution equals that probability.
Example
F.INV (0.01, 6, 4)
F.INV (0,01; 6; 4)
Returns roughly 0.11.