Manuals/calci/CHITEST

From ZCubes Wiki
Revision as of 21:31, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">''' CHITEST ''' ('''a, b''') Where ‘a ‘is the observations to test against the expected values and ‘b’ is the ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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:

Aij = 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