Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x. The F distribution can be used in an F-test 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.

F.INV takes 3 required arguments and no optional arguments:

Syntax: F.INV(probability, deg_freedom1, deg_freedom2)

#1)
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.
comments powered by Disqus