FINV Function

The FINV function returns the p^th quantile from the F distribution with numerator degrees of freedom ndf, denominator degrees of freedom ddf, and noncentrality parameter nc. The probability that an observation from the F distribution is less than the quantile is p. This function accepts noninteger degrees of freedom parameters ndf and ddf.

If the optional parameter nc is not specified or has the value 0, the quantile from the central F distribution is returned. The noncentrality parameter nc is defined such that if X and Y are normal random variables with means μ and 0, respectively, and variance 1, then $X^2/Y^2$ has a noncentral F distribution with nc = μ².