Spread Formula Reference
FINV
Formula Functions > Functions D to G > FINV

This function returns the inverse of the F probability distribution.

Syntax

FINV(p,degnum,degden)

Arguments

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.

Remarks

This function calculates the inverse of the F probability distribution, so if p = FDIST(x,...), then FINV(p,...) = x.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

FINV(A1,2,2)

FINV(R1C1,2,1)

FINV(0.021,5,3) gives the result 16.83975

Version Available

This function is available in product version 1.0 or later.

See Also

FDIST | Statistical Functions