Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / CHIINV
In This Topic
    CHIINV
    In This Topic

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

    Syntax

    CHIINV(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

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    CHIINV(B5,D7)

    CHIINV(R5C2,R7C4)

    CHIINV(0.75,4) gives the result 1.9225575262

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CHIDIST | CHITEST | Statistical Functions