SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / 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