F.INV Function Explained
The F.INV Function in Microsoft Excel returns the inverse of the F-Distribution. It takes three arguments: probability, deg_freedom1, and deg_freedom2. The probability argument is the probability associated with the F-Distribution, and the deg_freedom1 and deg_freedom2 arguments are the degrees of freedom for the numerator and denominator, respectively. The result of the function is the value of the inverse of the F-Distribution for the given probability, degrees of freedom, and significance level.
F.INV Function Syntax
F.INV(probability,deg_freedom1,deg_freedom2)
- probability: The probability associated with the two-tailed F-distribution. Must be a number between 0 and 1.
- deg_freedom1: The numerator degrees of freedom. Must be a positive number.
- deg_freedom2: The denominator degrees of freedom. Must be a positive number.