Spread Silverlight Documentation
Spread Silverlight Documentation / Formula Reference / Formula Functions / FINV
In This Topic
    FINV
    In This Topic

    Summary

    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