How are income and degree related? The American National Election Survey asked respondents who reported at least 13 years of education to identify the highest degree completed (DEGREE: 0=No Degree earned, 1=Bachelor’s degree, 2=Master’s degree, 3=Ph.D., etc.,4=LLB, 5=MD,DDS, etc., 6=JDC,STD,THD, 7=Associate’s degree. Is there enough statistical evidence to conclude that there are differences in income (INCOME) between people with different completed degrees? Use a 5% significance level.

ONLY USE EXCEL AND PLEASE SHOW ALL EXCEL COMMANDS!

ID DEGREE INCOME EDUC

1 0 127500 13

3 1 32500 16

5 1 82500 16

6 0 6250 14

7 1 23500 16

8 7 82500 14

9 0 37500 14

10 7 82500 16

14 0 47500 15

15 7 11750 15

16 2 82500 17

18 7 37500 15

19 1 55000 16

20 1 82500 16

21 1 27500 16

23 7 27500 14

25 0 37500 14

27 0 67500 15

30 7 105000 15

32 1 55000 16

33 0 11750 14

34 7 8750 14

35 1 32500 16

36 7 32500 14

37 2 55000 17

38 7 18500 14

39 0 27500 14

40 7 67500 14

41 0 32500 15

42 7 16000 17

44 1 32500 16

45 1 95000 16

46 1 1500 16

47 7 37500 14

48 2 42500 17

50 2 105000 17

51 0 18500 13

52 0 23500 14

54 0 21000 13

57 0 16000 14

58 1 42500 16

59 0 55000 13

60 7 27500 14

61 7 175000 14

62 1 23500 17

63 1 6250 17

65 1 127500 17

66 1 67500 17

67 3 175000 17

68 1 55000 16

69 7 82500 14

70 0 1500 14

71 7 10500 14

73 3 55000 17

74 1 67500 17

75 2 11750 17

76 1 23500 17

77 1 27500 16

78 0 23500 14

79 0 42500 17

82 1 95000 16

85 1 67500 16

86 0 23500 14

87 0 18500 15

88 1 67500 16

89 0 23500 13

90 1 37500 15

92 7 27500 14

93 7 4000 14

94 0 6250 13

95 0 21000 14

96 0 32500 13

97 0 10500 16

98 1 8750 17

102 0 16000 13

104 0 8750 14

105 0 6250 14

108 1 42500 16

109 1 37500 16

113 1 55000 16

114 0 55000 13

116 0 42500 15

119 2 55000 17

122 7 67500 14

128 2 67500 17

129 7 18500 15

130 0 16000 14

131 0 27500 13

133 0 8750 14

134 0 21000 17

135 0 67500 14

136 1 105000 16

138 0 13750 13

143 1 82500 16

145 0 95000 14

147 0 67500 14

148 0 23500 14

149 1 175000 16

150 0 142500 15

151 2 127500 17

152 0 11750 13

154 0 67500 13

155 1 6250 16

156 1 42500 16

157 0 27500 13

159 1 127500 16

160 0 6250 14

162 1 105000 16

164 0 8750 14

170 0 21000 15

171 1 47500 16

172 2 175000 17

173 1 127500 17

175 1 47500 16

177 2 11750 17

182 0 1500 14

183 0 11750 14

185 1 1500 16

186 1 8750 16

187 0 82500 13

189 1 55000 16

190 1 32500 17

191 7 27500 14

192 0 175000 13

193 5 115000 17

194 1 42500 17

195 1 142500 17

197 7 6250 14

199 0 105000 15

201 1 82500 16

202 1 175000 16

204 7 175000 14

206 1 67500 16

208 7 55000 14

211 2 23500 16

213 0 18500 13

216 0 32500 13

218 7 47500 14

220 0 23500 13

222 0 67500 13

224 0 32500 13

227 0 67500 13

229 0 47500 14

232 7 11750 14

233 1 67500 16

234 0 55000 13

235 7 4000 16

236 7 42500 14

237 0 32500 14

238 0 8750 13

240 2 27500 17

241 0 175000 13

242 0 67500 14

243 1 4000 16

244 0 67500 15

245 1 105000 17

250 0 32500 13

251 0 37500 13

253 7 32500 14

254 2 47500 17

256 0 16000 13

258 0 47500 14

262 0 115000 14

269 1 10500 16

271 1 55000 16

272 7 1500 15

274 1 67500 16

276 7 175000 16

278 2 32500 17

279 1 67500 16

280 1 18500 15

281 1 105000 16

282 2 82500 17

283 1 55000 16

284 2 95000 17

285 1 37500 16

286 1 32500 16

287 0 4000 14

288 1 32500 17

289 0 55000 13

291 1 18500 16

292 1 82500 16

293 0 42500 14

294 0 11750 14

295 0 18500 14

298 2 6250 16

299 2 1500 17

300 0 16000 14

302 0 16000 13

303 7 13750 16

304 0 23500 13

307 1 8750 17

308 0 47500 13

309 1 47500 14

310 1 82500 17

312 7 67500 16

314 2 67500 17

321 1 105000 16

322 7 37500 15

324 0 1500 15

325 3 82500 17

327 2 67500 17

329 0 47500 14

330 7 95000 14

333 1 1500 16

334 1 55000 16

335 1 18500 16

336 0 67500 13

337 0 1500 13

338 1 175000 16

339 1 18500 16

340 1 55000 16

341 1 67500 16

342 0 6250 14

343 0 23500 14

349 1 55000 16

350 7 1500 14

352 1 32500 17

354 1 55000 17

356 0 47500 14

357 2 55000 17

358 0 1500 13

359 1 1500 17

360 0 47500 14

361 7 55000 14

362 7 67500 14

363 7 95000 14

365 0 16000 13

367 0 10500 14

369 1 95000 16

Question

How are income and degree related? The American National Election Survey asked respondents who reported at least 13 years of education to identify the highest degree completed (DEGREE: 0=No Degree earned, 1=Bachelor’s degree, 2=Master’s degree, 3=Ph.D., etc.,4=LLB, 5=MD,DDS, etc., 6=JDC,STD,THD, 7=Associate’s degree. Is there enough statistical evidence to conclude that there are differences in income (INCOME) between people with different completed degrees? Use a 5% significance level.

ONLY USE EXCEL AND PLEASE SHOW ALL EXCEL COMMANDS!

ID	DEGREE	INCOME	EDUC
1	0	127500	13
3	1	32500	16
5	1	82500	16
6	0	6250	14
7	1	23500	16
8	7	82500	14
9	0	37500	14
10	7	82500	16
14	0	47500	15
15	7	11750	15
16	2	82500	17
18	7	37500	15
19	1	55000	16
20	1	82500	16
21	1	27500	16
23	7	27500	14
25	0	37500	14
27	0	67500	15
30	7	105000	15
32	1	55000	16
33	0	11750	14
34	7	8750	14
35	1	32500	16
36	7	32500	14
37	2	55000	17
38	7	18500	14
39	0	27500	14
40	7	67500	14
41	0	32500	15
42	7	16000	17
44	1	32500	16
45	1	95000	16
46	1	1500	16
47	7	37500	14
48	2	42500	17
50	2	105000	17
51	0	18500	13
52	0	23500	14
54	0	21000	13
57	0	16000	14
58	1	42500	16
59	0	55000	13
60	7	27500	14
61	7	175000	14
62	1	23500	17
63	1	6250	17
65	1	127500	17
66	1	67500	17
67	3	175000	17
68	1	55000	16
69	7	82500	14
70	0	1500	14
71	7	10500	14
73	3	55000	17
74	1	67500	17
75	2	11750	17
76	1	23500	17
77	1	27500	16
78	0	23500	14
79	0	42500	17
82	1	95000	16
85	1	67500	16
86	0	23500	14
87	0	18500	15
88	1	67500	16
89	0	23500	13
90	1	37500	15
92	7	27500	14
93	7	4000	14
94	0	6250	13
95	0	21000	14
96	0	32500	13
97	0	10500	16
98	1	8750	17
102	0	16000	13
104	0	8750	14
105	0	6250	14
108	1	42500	16
109	1	37500	16
113	1	55000	16
114	0	55000	13
116	0	42500	15
119	2	55000	17
122	7	67500	14
128	2	67500	17
129	7	18500	15
130	0	16000	14
131	0	27500	13
133	0	8750	14
134	0	21000	17
135	0	67500	14
136	1	105000	16
138	0	13750	13
143	1	82500	16
145	0	95000	14
147	0	67500	14
148	0	23500	14
149	1	175000	16
150	0	142500	15
151	2	127500	17
152	0	11750	13
154	0	67500	13
155	1	6250	16
156	1	42500	16
157	0	27500	13
159	1	127500	16
160	0	6250	14
162	1	105000	16
164	0	8750	14
170	0	21000	15
171	1	47500	16
172	2	175000	17
173	1	127500	17
175	1	47500	16
177	2	11750	17
182	0	1500	14
183	0	11750	14
185	1	1500	16
186	1	8750	16
187	0	82500	13
189	1	55000	16
190	1	32500	17
191	7	27500	14
192	0	175000	13
193	5	115000	17
194	1	42500	17
195	1	142500	17
197	7	6250	14
199	0	105000	15
201	1	82500	16
202	1	175000	16
204	7	175000	14
206	1	67500	16
208	7	55000	14
211	2	23500	16
213	0	18500	13
216	0	32500	13
218	7	47500	14
220	0	23500	13
222	0	67500	13
224	0	32500	13
227	0	67500	13
229	0	47500	14
232	7	11750	14
233	1	67500	16
234	0	55000	13
235	7	4000	16
236	7	42500	14
237	0	32500	14
238	0	8750	13
240	2	27500	17
241	0	175000	13
242	0	67500	14
243	1	4000	16
244	0	67500	15
245	1	105000	17
250	0	32500	13
251	0	37500	13
253	7	32500	14
254	2	47500	17
256	0	16000	13
258	0	47500	14
262	0	115000	14
269	1	10500	16
271	1	55000	16
272	7	1500	15
274	1	67500	16
276	7	175000	16
278	2	32500	17
279	1	67500	16
280	1	18500	15
281	1	105000	16
282	2	82500	17
283	1	55000	16
284	2	95000	17
285	1	37500	16
286	1	32500	16
287	0	4000	14
288	1	32500	17
289	0	55000	13
291	1	18500	16
292	1	82500	16
293	0	42500	14
294	0	11750	14
295	0	18500	14
298	2	6250	16
299	2	1500	17
300	0	16000	14
302	0	16000	13
303	7	13750	16
304	0	23500	13
307	1	8750	17
308	0	47500	13
309	1	47500	14
310	1	82500	17
312	7	67500	16
314	2	67500	17
321	1	105000	16
322	7	37500	15
324	0	1500	15
325	3	82500	17
327	2	67500	17
329	0	47500	14
330	7	95000	14
333	1	1500	16
334	1	55000	16
335	1	18500	16
336	0	67500	13
337	0	1500	13
338	1	175000	16
339	1	18500	16
340	1	55000	16
341	1	67500	16
342	0	6250	14
343	0	23500	14
349	1	55000	16
350	7	1500	14
352	1	32500	17
354	1	55000	17
356	0	47500	14
357	2	55000	17
358	0	1500	13
359	1	1500	17
360	0	47500	14
361	7	55000	14
362	7	67500	14
363	7	95000	14
365	0	16000	13
367	0	10500	14
369	1	95000	16

Accepted Answer

Given:

ID
DEGREE
INCOME
EDUC

1
0
127500
13

3
1
32500
16

5
1
82500
16

6
0
6250
14

7
1…