FINV Function Explained
The FINV Function in Microsoft Excel is used to calculate the inverse of the F-distribution. It takes three arguments: probability, deg_freedom1, and deg_freedom2. It returns the F-value associated with the given probability, degrees of freedom, and cumulative distribution function.
FINV Function Syntax
FINV(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.