Navigation:  Formula Reference > Spreadsheet Formula Functions >

FINV

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

FDIST