Spread.Sheets Documentation
F.INV
Spread.Sheets Documentation > Formula Reference > Formula Functions > F.INV

This function returns the inverse of the F probability distribution.

Syntax

F.INV(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

Remarks

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

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

F.INV(A1,2,2)

F.INV(R1C1,2,1)

F.INV(0.021,5,3) gives the result 0.11813305544967191