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
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
A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
Related questions
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 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 1 images
Recommended textbooks for you
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON