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
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.
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.
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.
3.149.29.71