Spread Formula Reference
Formula Functions / Functions D to G / FINV
In This Topic
    FINV
    In This Topic

    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