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.
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:
- If either deg_freedom1 or deg_freedom2 is a decimal number, it is truncated to integers by Excel.
- #NUM! error – Occurs if either:
- The probability that is provided is less than 0 or greater than or equal to 1.
- The argument deg_freedom1 or deg_freedom2 is less than 1.
- #VALUE! error – Occurs when any of the arguments provided is non-numeric.
- 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.