SpreadJS 14
Formula Reference / Formula Functions / Statistical Functions / CHISQ.DIST
In This Topic
    CHISQ.DIST
    In This Topic

    This function calculates the chi-squared distribution.

    Syntax

    CHISQ.DIST(value,deg,cumulative)

    Arguments

    This function has these arguments:

    Argument Description
    value Value at which to evaluate the function
    deg Number of degrees of freedom; 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 value and deg arguments. Returns numeric data.

    Examples

    CHISQ.DIST(B5,D7,TRUE)

    CHISQ.DIST(R5C2,R7C4,TRUE)

    CHISQ.DIST(6.7,4,TRUE) gives the result 0.8473830596613241