Chi2Test_p() returns the aggregated chi2-test p value (significance) for one or two series of values. The test can be done either on the values in actual_value, testing for variations within the specified col and row matrix, or by comparing values in actual_value with corresponding values in expected_value, if specified.
If the function is used in the load script, the values are iterated over a number of records as defined by a group by clause.
If the function is used in a chart expression, the values are iterated over the chart dimensions.
Syntax:
Chi2Test_p(col, row, actual_value[, expected_value])
Return data type: numeric
Arguments:
- col, row: The specified column and row in the matrix of values being tested.
- actual_value: The observed value of the data at the specified col and row.
- expected_value: The expected value for the distribution at the specified col and row.
Limitations:
Text values, NULL values and missing values in the expression value will result in the function returning NULL.
Examples:
Chi2Test_p( Grp, Grade, Count )
Chi2Test_p( Gender, Description, Observed, Expected )
