Spread Formula Reference
Formula Functions / Functions A to C / CHISQ.INV.RT
In This Topic
    CHISQ.INV.RT
    In This Topic

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

    Syntax

    CHISQ.INV.RT(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

    The #VALUE! error value is returned if either argument is nonnumeric.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    CHISQ.INV.RT(B5,D7)

    CHISQ.INV.RT(R5C2,R7C4)

    CHISQ.INV.RT(0.75,4) gives the result 1.9225575262293264

    Version Available

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

    See Also

    CHISQ.DIST