F.INV
Calculates the inverse of the lefttailed F probability distribution. Also called the FisherSnedecor distribution or Snedecor’s F distribution.
Sample Usage
F.INV(0.42, 2, 3)
F.INV(A2, B2, C2)
Syntax
F.INV(probability, degrees_freedom1, degrees_freedom2)

probability
 The probability associated with the lefttailed Fdistribution.
Must be greater than
0
and less than1
.


degrees_freedom1
 The number of degrees of freedom of the numerator of the test statistic. 
degrees_freedom2
 The number of degrees of freedom of the denominator of the test statistic.
Notes

Both
degrees_freedom1
anddegrees_freedom2
are truncated to an integer in the calculation if a noninteger is provided as an argument. 
Both
degrees_freedom1
anddegrees_freedom2
must be at least1
. 
All arguments must be numeric.
See Also
CHIINV
: Calculates the inverse of the righttailed chisquared distribution.
FDIST
: Calculates the righttailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called FisherSnedecor distribution or Snedecor's F distribution.
FINV
: Calculates the inverse of the righttailed F probability distribution. Also called the FisherSnedecor distribution or Snedecor’s F distribution.
FTEST
: Returns the probability associated with an Ftest for equality of variances. Determines whether two samples are likely to have come from populations with the same variance.
T.INV
: Calculates the negative inverse of the onetailed TDIST function.
Example
Suppose you want to find the cutoff for the F statistic associated with a lefttailed cumulative probability of 0.95
.
A  B  C  D  

1  Probability  Degrees freedom numerator  Degrees freedom denominator  Solution 
2  0.95  4  5  5.192167773 
3  0.95  4  5  =F.INV(0.95, 4, 5) 
4  0.95  4  5  =F.INV(A2, B2, C2) 