Manuals/calci/CHITEST

CHITEST (a, b)

Where ‘a ‘is the observations to test against the expected values and ‘b’ is the ratio of the product of row totals and column totals to the grand total.

This function returns the test for independence.

Sometimes CHITEST returns the error value, when ‘a’ and ‘b’ have a different number of data points.

It is calculated using the formula:

Where:

A_{ij = actual frequency in the i-th row, j-th column}

Eij = expected frequency in the i-th row, j-th column

r = number or rows and c = number of columns

χ^{2 is always positive or 0, and is 0 only if Aij = Eij for every i, j.}

CHITEST

Syntax

Remarks

Examples

Description

	Column1	Column2	Column3	Column4
Row1	45	38	0.000313
Row2	10	23
Row3	12	26
Row4	40.5	49.36
Row5	19.56	16.44
Row6	17.05	17.41

AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.

Let’s see an example

B C

45 38

10 23

12 26

40.5 49.36

19.56 16.44

17.05 17.41

CHITEST (a, b)

i.e. =CHITEST (B2; C4, B5:C7) is 0.003