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

    This function calculates the test for independence from the chi-squared distribution.

    Syntax

    CHISQ.TEST(obs_array,exp_array)

    Arguments

    This function has these arguments:

    Argument Description
    obs_array Array of observed values to test against expected values
    exp_array Array of expected values against which to test observed values

    Remarks

    The arrays in the arguments must be of the same size.

    Data Types

    Accepts arrays of numeric data for both arguments. Returns numeric data.

    Examples

    CHISQ.TEST(B1:C8,B12:C19)

    CHISQ.TEST(R1C2:R8C3,R12C2:R19C3)

    Version Available

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

    See Also

    CHISQ.DIST