F.INV.RT (Probability, DegreesOfFreedom1, DegreesOfFreedom2) F.INV.RT (Probability; DegreesOfFreedom1; DegreesOfFreedom2)
Probability
Number Number
The probability, which must be between 0 and 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 right-tailed F distribution equals the given probability.
Returns the inverse of the right-tailed F.DIST.RT function. Given a probability, this function returns the value that the F distribution exceeds with that probability. This is the critical value of an F-test at the significance level given by the Probability parameter.
Example
F.INV.RT (0.01, 6, 4)
F.INV.RT (0,01; 6; 4)
Returns roughly 15.21.