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
2 16000 12
3 1 32500 16
4 23500 12
5 1 82500 16
6 0 6250 14
7 1 23500 16
8 7 82500 14
9 0 37500 14
10 7 82500 16
11 0 15
12 82500 12
13 18500 12
14 0 47500 15
15 7 11750 15
16 2 82500 17
17 8750 12
18 7 37500 15
19 1 55000 16
20 1 82500 16
21 1 27500 16
22 21000 12
23 7 27500 14
24 8750 6
25 0 37500 14
26 37500 12
27 0 67500 15
28 95000 12
29 82500 12
30 7 105000 15
31 16000 12
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
43 0 13
44 1 32500 16
45 1 95000 16
46 1 1500 16
47 7 37500 14
48 2 42500 17
49 55000 12
50 2 105000 17
51 0 18500 13
52 0 23500 14
53 11750 12
54 0 21000 13
55 55000 12
56 0 14
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
64 32500 12
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
72 13750 12
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
80 13750 10
81 12
82 1 95000 16
83 6250 12
84 1500 12
85 1 67500 16
86 0 23500 14
87 0 18500 15
88 1 67500 16
89 0 23500 13
90 1 37500 15
91 27500 12
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
99 12
100 8750 12
101 21000 12
102 0 16000 13
103 10500 16
104 0 8750 14
105 0 6250 14
106 11750 12
107 82500 12
108 1 42500 16
109 1 37500 16
110 8750 12
111 1500 12
112 18500 11
113 1 55000 16
114 0 55000 13
115 0 13
116 0 42500 15
117 21000 12
118 42500 11
119 2 55000 17
120 18500 12
121 0 14
122 7 67500 14
123 1500 12
124 27500 12
125 6250 12
126 21000 12
127 1500 11
128 2 67500 17
129 7 18500 15
130 0 16000 14
131 0 27500 13
132 4000 12
133 0 8750 14
134 0 21000 17
135 0 67500 14
136 1 105000 16
137 23500 11
138 0 13750 13
139 16000 10
140 13750 12
141 13750 12
142 95000 12
143 1 82500 16
144 1 17
145 0 95000 14
146 18500 12
147 0 67500 14
148 0 23500 14
149 1 175000 16
150 0 142500 15
151 2 127500 17
152 0 11750 13
153 7 14
154 0 67500 13
155 1 6250 16
156 1 42500 16
157 0 27500 13
158 32500 12
159 1 127500 16
160 0 6250 14
161 11750 10
162 1 105000 16
163 0 15
164 0 8750 14
165 27500 6
166 175000 12
167 18500 4
168 27500 6
169 37500 11
170 0 21000 15
171 1 47500 16
172 2 175000 17
173 1 127500 17
174 1 16
175 1 47500 16
176 1 17
177 2 11750 17
178 13750 12
179 1 16
180 10500 10
181 11750 11
182 0 1500 14
183 0 11750 14
184 175000 9
185 1 1500 16
186 1 8750 16
187 0 82500 13
188 32500 12
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
196 47500 12
197 7 6250 14
198 16000 12
199 0 105000 15
200 16000 12
201 1 82500 16
202 1 175000 16
203 6
204 7 175000 14
205 0 16
206 1 67500 16
207 1500 12
208 7 55000 14
209 37500 12
210 1500 12

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

More Books

Students also viewed these Mathematics questions