Related Functions:

The F.INV.RT function returns the inverse of the (right-tailed) F probability distribution, i.e. if , then .

• This function was introduced in Excel 2010 and so is not available in earlier versions.
• The F.INV.RT function replaces the FINV function included in earlier versions of Excel.

### Syntax

=F.INV.RT(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.RT(A2,A3,A4) 1.22736 Inverse of the F probability distribution for the supplied terms

#### 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 supplied deg_freedom2 argument is < 1