I'm trying to learn how to run the chi squared test of independence. I've created two fictional variables, Variable 1 and Variable 2, and I want to know if they are correlated.
I'm working with the following values:
Variable 1 Variable 2 Row Total
Group 1 100 200 300
Group 2 150 300 450
Group 3 200 400 600
Group 4 250 500 750
Group 5 300 600 900
Col. Tot. 400 800 3000
Which gives me the following table:
Observed Expected (O – E) (O – E)^2 (O – E)^2/E
100 40 60 3600 90
150 60 90 8100 135
200 80 120 14400 180
250 100 150 22500 225
300 120 180 32400 270
200 80 120 14400 180
300 120 180 32400 270
400 160 240 57600 360
500 200 300 90000 450
600 240 360 129600 540
Which gives me a X^2 of 2700. So, according to this test, Variable 1 and Variable 2 are not correlated. I just don't see how this could be possibly be true. Am I running the test wrong, or is my interpretation of how the test should work incorrect?