Spread Formula Reference
Formula Functions / Functions A to C / CHITEST
In This Topic
    CHITEST
    In This Topic

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

    Syntax

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

    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

    CHITEST(B1:C8,B12:C19)

    CHITEST(R1C2:R8C3,R12C2:R19C3)

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CHIDIST | CHIINV | AVERAGE | Statistical Functions