This function returns the inverse of the F probability distribution.
FINV(p,degnum,degden)
This function has these arguments:
Argument | Description |
---|---|
p | Probability associated with the F cumulative distribution |
degnum | Number of degrees of freedom for the numerator; if not an integer, the number is truncated |
degden | Number of degrees of freedom for the denominator; if not an integer, the number is truncated |
If either degnum or degden is not an integer, it is truncated.
This function calculates the inverse of the F probability distribution, so if p = FDIST(x,...), then FINV(p,...) = x.
Accepts numeric data for all arguments. Returns numeric data.
FINV(A1,2,2)
FINV(R1C1,2,1)
FINV(0.021,5,3) gives the result 16.83975