Statistical - F.INV.RT Function

Description

The F.INV.RT function returns the inverse of the (right-tailed) F probability distribution.

If p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x.

The F distribution can be used in an F-test that compares the degree of variability in two data sets.

F.INV.RT (probability,deg_freedom1,deg_freedom2)

Argument	Description	Required/ Optional
Probability	A probability associated with the F cumulative distribution.	Required
Deg_freedom1	The numerator degrees of freedom.	Required
Deg_freedom2	The denominator degrees of freedom.	Required

If Deg_freedom1 or Deg_freedom2 is not an integer, it is truncated.
If any argument is non-numeric, F.INV.RT returns the #VALUE! error value.
If any argument is non-numeric, F.INV.RT returns the #VALUE! error value.
If Probability is < 0 or probability is > 1, F.INV.RT returns the #NUM! error value.
If Deg_freedom1 is < 1, or Deg_freedom2 is < 1, F.INV.RT returns the #NUM! error value.
If Deg_freedom2 is < 1 or Deg_freedom2 is ≥ 10^10, F.INV.RT returns the #NUM! error value.
Given a value for probability, F.INV.RT seeks that value x such that

F.DIST.RT(x, deg_freedom1, deg_freedom2) = probability
- Thus, precision of F.INV.RT depends on precision of F.DIST.RT.
- F.INV.RT uses an iterative search technique. If the search has not converged after 64 iterations, the function returns the #N/A error value.

Excel 2010, Excel 2013, Excel 2016

advanced_excel_statistical_functions.htm