SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / CHISQ.INV
In This Topic
    CHISQ.INV
    In This Topic

    This function calculates the inverse of the left-tailed probability of the chi-squared distribution.

    Syntax

    CHISQ.INV(prob,deg)

    Arguments

    This function has these arguments:

    Argument Description
    prob Probability of the chi-squared distribution
    deg Number of degrees of freedom; if not an integer, the number is truncated

    Remarks

    If the argument is nonnumeric, the function returns the #VALUE! error value.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    CHISQ.INV(B5,D7)

    CHISQ.INV(R5C2,R7C4)

    CHISQ.INV(0.75,4) gives the result 5.385269057779394