Advanced Excel Statistical - F.INV Function

Description

The F.INV function returns the inverse of the F probability distribution.

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.

Syntax

F.INV (probability,deg_freedom1,deg_freedom2)

Arguments

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

Notes

  • If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.

  • If any argument is nonnumeric, F.INV returns the #VALUE! error value.

  • If probability < 0 or probability > 1, F.INV returns the #NUM! error value.

  • If deg_freedom1 < 1, or deg_freedom2 < 1, F.INV returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

F.INV Function
advanced_excel_statistical_functions.htm
Advertisements