Spread Formula Reference
Formula Functions / Functions D to G / F.DIST.RT
In This Topic
    F.DIST.RT
    In This Topic

    This function calculates the F probability distribution, to see degrees of diversity between two sets of data.

    Syntax

    F.DIST.RT(value,degnum,degden)

    Arguments

    This function has these arguments:

    Argument Description
    value Value at which to evaluate the function
    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

    The #VALUE! error value is returned if any argument is nonnumeric.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    F.DIST.RT(A1,2,2)

    F.DIST.RT(R1C1,2,1)

    F.DIST.RT(16.83975,5,3) gives the result 0.021000082461949843

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    FDIST