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

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

    Syntax

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

    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
    cumulative A logical value that determines the form of the function. If cumulative is TRUE, this function returns the cumulative distribution function; if FALSE, it returns the probability density function

    Data Types

    Accepts numeric data for all arguments except cumulative. Returns numeric data.

    Examples

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

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

    F.DIST(16.83975,5,3,TRUE) gives the result 0.9789999175380504

    Version Available

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

    See Also

    FDIST