Posted by Bettie on Tuesday, April 16, 2013 at 6:05pm.
This looks like a chi-square test.
To find expected values for each cell, here is a formula you can use:
E = (row total)(column total)/n
...where E is the expected cell count if the null hypothesis is true.
The null hypothesis states the variables are unrelated in the population. The alternate or alternative hypothesis states the variables are related in the population. The purpose of a chi-square test is to determine if two or more variables are independent of each other (the null hypothesis) or are dependent (the alternate or alternative hypothesis). If the null is rejected, you can conclude that the variables are related in some manner or connected in some way. If the null is not rejected, you cannot conclude that the variables are related.
To calculate the chi-square statistic (after you have your expected values), you can use a formula like the following:
Chi sq = the sum of [(O - E)^2/E]
...where ^2 means squared.
(Take each cell, subtract the expected value from the observed value, square it, then divide by the expected value. Do this for each cell. Then add all the values together for the chi-square statistic.)
Using a table for critical or cutoff values for the chi-square, find the critical value using .01 level with degrees of freedom. Degrees of freedom = (r - 1)(c - 1) ...where r = number of rows and c = number of columns. If your test statistic exceeds the critical value from the table, then the null is rejected. If your test statistic does not exceed the critical value from the table, then the null is not rejected.
I hope this will help get you started.