O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

F.INV()

Syntax. F.INV(probability,degrees_freedom1,degrees_freedom2)

Definition. This function returns the quantile of the left F-distribution.

Arguments

  • probability (required). The probability associated with the F-distribution

  • degrees_freedom1 (required). The degrees of freedom in the numerator

  • degrees_freedom2 (required). The degrees of freedom in the denominator

Note

If one of the arguments isn’t a numeric expression, the F.INV() function returns the #VALUE! error.

If probability is less than 0 or greater than 1, the F.INV() function returns the #NUM! error.

If degrees_freedom1 or degrees_freedom2 isn’t an integer, the decimal places are truncated. If degrees_freedom1 is less than 1 or degrees_freedom2 is less than 1, the F.INV() function returns the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required