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 #NUM! error.

Background. The F.INV.RT() function describes the quantile of the right F-distribution, and the F.INV() function describes the left quantile.

See Also

You will find more information about ANOVA analyses and F-distributions in the description of F.INV.RT()/FINV().

Example. Compare the example for the F.INV.RT() function.

See Also

F.INV.RT(), F.TEST()

Sample Files

Use the F.INV worksheet in the Probability.xls sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.