How to use F.INV Function in Excel

The Excel F.INV function calculates the inverse of the Cumulative F Distribution for a supplied probability. If p = F.DIST(x,…), then F.INV(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.

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

The F.INV function syntax has the following arguments:

  • 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.

Example: Let’s look at some Excel F.INV function examples and explore how to use the F.INV function as a worksheet function in Microsoft Excel:

To find out the inverse of the F Probability Distribution using the F.INV function, we will use the following formula:

Syntax:  =F.INV(B1,B2,B3)

Result: 0.86037961

Note:

  1. If either deg_freedom1 or deg_freedom2 is a decimal number, it is truncated to integers by Excel.
  2. #NUM! error – Occurs if either:
    1. The probability that is provided is less than 0 or greater than or equal to 1.
    2. The argument deg_freedom1 or deg_freedom2 is less than 1.
  3. #VALUE! error – Occurs when any of the arguments provided is non-numeric.
  4. In MS Excel 2010, the F.INV function replaced the FINV function for better accuracy. FINV is still available in Excel but only for compatibility purposes.

Add a Comment

Your email address will not be published. Required fields are marked *