Difference between revisions of "Manuals/calci/CHITEST"
Jump to navigation
Jump to search
(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 ...") |
|||
| Line 1: | Line 1: | ||
| − | + | ''' 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. | 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. | + | *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<sub>ij = actual frequency in the i-th row, j-th column</sub> | ||
| + | Eij = expected frequency in the i-th row, j-th column | ||
| − | + | r = number or rows and c = number of columns | |
| − | |||
| − | |||
| − | + | χ<sup>2 is always positive or 0, and is 0 only if Aij = Eij for every i, j.</sup> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| class=" " | | | class=" " | | ||
| − | + | ||
| class=" " | Column1 | | class=" " | Column1 | ||
| class=" " | Column2 | | class=" " | Column2 | ||
| Line 87: | Line 63: | ||
|} | |} | ||
| − | + | Let’s see an example | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | 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 | |
| − | |||
Revision as of 06:27, 22 November 2013
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.
| 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 |
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