Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Stochastic Calculus With Infinitesimals

Authors: Frederik S Herzberg

1st Edition

3642331491, 9783642331497

More Books

Students also viewed these Mathematics questions

Question

Values: What is important to me?

Answered: 1 week ago

Question

Purpose: What do we seek to achieve with our behaviour?

Answered: 1 week ago