F.INV:
Returns the inverse of the F probability distribution
Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x.
The F distribution can be used in an Ftest that compares the degree of variability in two data sets.
For example, you can analyze income distributions in the United States and Canada to determine whether the two countries have a similar degree of income diversity.
The arguments for the F.INV function are:
Argument

Required?

Description

probability 
Required 
A probability associated with the F cumulative distribution. 
deg_freedom1 
Required 
The numerator degrees of freedom. 
deg_freedom2 
Required 
The denominator degrees of freedom. 