In This Topic

FINV

In This Topic

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

This function is available in product version 1.0 or later.