Chi2Test_chi2 - script and chart function
Chi2Test_chi2() returns the aggregated chi2-test value for one or two series of values.
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_chi2(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_chi2( Grp, Grade, Count )
Chi2Test_chi2( Gender, Description, Observed, Expected )