Spread 8.0 Documentation
FINV
Support Options
Formula Reference > Built-In Functions > FINV

Glossary Item Box

FINV


Name

F inverse

Description

Returns the inverse of the F probability distribution.

Syntax

FINV(p, degnum, degden)

Remarks

Arguments are as follows:

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..

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

FINV(A1,2,2) FINV(R1C1,2,1)
FINV(0.021,5,3)=16.83975

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.