Related Functions:

The F.INV function returns the inverse of the cumulative F Distribution for a supplied probability, e.g. If    p = \text{F.DIST}(x,...), then x = \text{F.INV}(p,...).

  • This function was introduced in Excel 2010 and so is not available in earlier versions.

Syntax

=F.INV(probability,deg_freedom1,deg_freedom2)

Arguments

Argument Description
probability A probability associated with the F cumulative distribution
deg_freedom1 An integer specifying the numerator degrees of freedom
deg_freedom2 An integer specifying the denominator degrees of freedom

Examples

  A B C D
1 Data Description    
2 0.45 Probability associated with the F cumulative distribution   
3 8 Numerator degrees of freedom   
4 4 Denominator degrees of freedom   
5        
6 Formula Result Notes
7 =F.INV(A2,A3,A4) 0.975459 Inverse of the F probability distribution for the supplied terms

Usage note: 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.

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NUM! Occurs if either:

  the supplied probability value is < 0 or ≥ 1
  the supplied deg_freedom1 or the deg_freedom2 argument is < 1
#NAME? Occurs when Analysis ToolPak add-in is not enabled