This function returns the inverse of the F-distribution.
Syntax:
FINV (prob, degrees_freedom1, degrees_freedom2)
This function is related to the FDIST function in the following way:
If prob = fdist(value, df1, df2), then finv(prob, df1, df2) = value.
Arguments:
| Argument | Description |
|---|---|
| prob | A probability associated with the F-distribution and must be a number between 0 and 1. |
| degrees_freedom | An integer stating the number of degrees of freedom. |
Limitations:
All arguments must be numeric, else NULL will be returned.