FINV

Definition: FINV is a function that returns the inverse of the F probability distribution for a specified set of parameters.

Syntax: =FINV(probability, degrees_freedom1, degrees_freedom2)

Situation: This formula is suitable when you need to find the inverse of the F probability distribution for a specified set of parameters.

Example: If you have a probability of 0.05 and degrees of freedom of 10 in the numerator and 20 in the denominator, the inverse of the F distribution can be found using the formula =FINV(0.05, 10, 20), which returns 0.394.