Spread Silverlight Documentation
Spread Silverlight Documentation / Formula Reference / Formula Functions / CHITEST
In This Topic
    CHITEST
    In This Topic

    Summary

    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)

    See Also