12-one_true_love_chi-square-example_calculations.xlsx

	A	B	C	D	E	F	I	J	K	L	M	O	P	Q	R	S	U	V	W	X	Y	AA	AB	AC	AD	AE	AG
1		HS	Some	College	Total
2	Agree	363	176	196	735
3	Disagree	557	466	789	1812
4	Don't Know	20	26	32	78
5	Total	940	668	1017	2625
6
7
8
9
10		HS	Some	College	Total
11	Agree				735
12	Disagree				1812
13	Don't Know				78
14	Total	940	668	1017	2625
15
16
17		HS	Some	College	Total	prop of total
18	Agree				735	0.28
19	Disagree				1812	0.69
20	Don't Know				78	0.03
21	Total	940	668	1017	2625
22
23
24		HS	Some	College	Total	prop of total
25	Agree	.28*940			735	0.28
26	Disagree				1812	0.69
27	Don't Know				78	0.03
28	Total	940	668	1017	2625
29
30
31		HS	Some	College	Total	prop of total
32	Agree	.28*940			735	0.28
33	Disagree	.69*940			1812	0.69
34	Don't Know	.03*940			78	0.03
35	Total	940	668	1017	2625
36
37
38		HS	Some	College	Total	prop of total
39	Agree	263.2			735	0.28
40	Disagree	648.6			1812	0.69
41	Don't Know	28.2			78	0.03
42	Total	940	668	1017	2625
43
44		HS	Some	College	Total	prop of total
45	Agree	263.2	.28*668		735	0.28
46	Disagree	648.6	.69*668		1812	0.69
47	Don't Know	28.2	.03*668		78	0.03
48	Total	940	668	1017	2625
49
50
51		HS	Some	College	Total	prop of total
52	Agree	263.2	187.04		735	0.28
53	Disagree	648.6	460.92		1812	0.69
54	Don't Know	28.2	20.04		78	0.03
55	Total	940	668	1017	2625
56
57
58		HS	Some	College	Total	prop of total
59	Agree	263.2	187.04	.28*1017	735	0.28
60	Disagree	648.6	460.92	.69*1017	1812	0.69
61	Don't Know	28.2	20.04	0.03*1017	78	0.03
62	Total	940	668	1017	2625
63
64
65		HS	Some	College	Total	prop of total
66	Agree	263.2	187.04	284.76	735	0.28
67	Disagree	648.6	460.92	701.73	1812	0.69
68	Don't Know	28.2	20.04	30.51	78	0.03
69	Total	940	668	1017	2625
70
71
72	Expected						Actual (observed)					Difference (observed-expected)					Difference squared					Difference squared/ expected count
73
74		HS	Some	College	Total	prop of total		HS	Some	College	Total		HS	Some	College	Total		HS	Some	College	Total		HS	Some	College	Total
75	Agree	263.2	187.04	284.76	735	0.28	Agree	363	176	196	735	Agree	99.8	-11.04	-88.76		Agree	9960.04	121.8816	7878.3376		Agree	37.8	0.7	27.7		Chi square statistic is the sum of the cells
76	Disagree	648.6	460.92	701.73	1812	0.69	Disagree	557	466	789	1812	Disagree	-91.6	5.08	87.27		Disagree	8390.56	25.8064	7616.0529		Disagree	12.9	0.1	10.9		94.2
77	Don't Know	28.2	20.04	30.51	78	0.03	Don't Know	20	26	32	78	Don't Know	-8.2	5.96	1.49		Don't Know	67.24	35.5216	2.2201		Don't Know	2.4	1.8	0.1
78	Total	940	668	1017	2625		Total	940	668	1017	2625	Total					Total					Total
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100