- Question 2 Refer To The Wage Data Given In Table 1 And Consider The Following Model A B Wage B1 B2education B3 1 (55.06 KiB) Viewed 101 times
Table 1: Wage and Related Data for 523
Workers
- Question 2 Refer To The Wage Data Given In Table 1 And Consider The Following Model A B Wage B1 B2education B3 2 (46.09 KiB) Viewed 101 times
- Question 2 Refer To The Wage Data Given In Table 1 And Consider The Following Model A B Wage B1 B2education B3 3 (46.49 KiB) Viewed 101 times
- Question 2 Refer To The Wage Data Given In Table 1 And Consider The Following Model A B Wage B1 B2education B3 4 (41.97 KiB) Viewed 101 times
- Question 2 Refer To The Wage Data Given In Table 1 And Consider The Following Model A B Wage B1 B2education B3 5 (31.14 KiB) Viewed 101 times
- Question 2 Refer To The Wage Data Given In Table 1 And Consider The Following Model A B Wage B1 B2education B3 6 (18.09 KiB) Viewed 101 times
- Question 2 Refer To The Wage Data Given In Table 1 And Consider The Following Model A B Wage B1 B2education B3 7 (14.51 KiB) Viewed 101 times
calculation.. i know the data is a bit more.. appreciate your
works!
QUESTION 2 Refer to the wage data given in Table 1 and consider the following model: a. b. Wage; = B1 + B2Education; +B3 Experience; + ui Estimate the regression. (5 marks) For this regression, obtain the absolute values of the residuals as well as their squared values and plot each against education and experience. Is there any evidence of heteroscedasticity? (10 marks) Do the Park and Glejser tests on the residuals of this regression with the estimated wage (Wage:) is treated as the independent variable. What condusions can you draw? (5 Marks) If heteroscedasticity is found, what kind of WLS transformation would you recommend to eliminate it? (5 Marks) Run the WLS transformation regression and show the results (5 Marks) C. . d. e e.
Experience 21 42 1 4 17 9 Experience 13 12 8 23 13 9 21 44 27 4 9 11 9 17 19 42 27 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Wage 6.63 6.44 8.68 5.20 9.75 17.00 5.79 25.32 17.27 11.38 14.76 14.95 8.45 8.13 25.98 9.49 10.40 28.86 4.75 26.72 7.43 9.10 4.88 5.85 12.43 7.48 12.17 8.45 4.36 6.18 11.57 5.20 6.11 6.50 Education 9 10 14 14 14 15 12 14 19 14 14 14 9 10 10 14 8 14 13 14 14 8 14 13 14 7 14 12 14 14 16 14 9 20 ID 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 30 29 37 44 26 16 33 16 42 9 14 23 45 8 30 8 8 13 46 19 1 Wage 18.20 13.00 8.45 12.78 24.05 16.25 33.80 18.20 13.65 14.30 16.22 16.25 19.50 7.80 12.35 6.50 4.88 16.35 8.95 7.15 9.10 5.85 8.45 15.60 6.50 8.45 8.84 11.38 4.88 5.85 7.80 7.15 16.90 7.35 Education 13 12 14 14 16 14 16 6 14 9 15 14 14 14 13 19 13 14 9 14 14 14 14 14 14 14 10 15 14 14 14 14 14 16 10 11 40 8 29 3 11 12 22 12 7 15 28 ID 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 Wage 11.44 11.70 23.61 10.16 13.81 5.85 22.43 13.65 11.99 19.50 29.25 5.92 11.70 17.33 19.50 9.75 5.53 16.25 6.67 4.36 14.45 5.00 8.32 7.23 13.00 7.35 14.95 4.55 4.36 6.18 25.98 4.55 5.20 9.10 Education 16 19 20 14 19 14 18 15 16 19 21 15 14 21 16 16 14 14 14 19 14 13 14 16 14 19 19 13 15 14 16 16 14 14 Experience 41 7 14 1 6 3 31 14 13 26 14 33 16 10 22 2 29 43 5 14 28 25 45 5 20 6 16 33 2 10 44 6 15 5 20 ch 6 5 30 18 6 16 1 3 8 2 A [/) al E
4 35 36 37 38 39 40 42 43 44 45 | 이 46 235 236 237 238 239 240 241 242 244 245 246 247 248 249 250 | 12.03 13.88 9.90 13.00 9.75 15.86 14.30 15.60 6.31 5.59 7.80 19.50 6.31 11.70 8.27 11.9 14.30 5.85 6.24 7.15 10.92 8.78 13.00 6.50 8.45 13.98 9.10 14.86 5.20 11.7 16.90 15.89 8.17 8.78 4.36 19 36 20 35 3 10 14 14 16 8 15 12 13 33 9 7 13 7 16 11 17 13 22 28 17 24 55 14 14 14 14 14 16 16 14 10 15 8 19 12 9 14 14 19 14 14 14 15 12 14 14 13 14 3 14 14 12 14 14 14 12 13 6.24 9.10 6.83 4.36 11.05 7.80 8.78 11.56 18.48 14.02 11.57 9.75 5.85 14.63 17.49 7.80 6.01 13.76 6.50 10.66 8.13 11.05 32.48 21.65 8.13 5.92 14.63 27.63 16.45 16 9 2 43 38 9 12 18 15 28 27 38 3 41 16 7 33 25 5 17 1 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 10 12 14 8 10 14 14 14 13 13 12 14 14 14 14 15 7 16 14 16 14 14 19 16 16 14 14 15 47 48 49 50 51 52 53 54 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 | 370 14 32 14 21 43 27 4 32 20 4 34 5 13 17 10 7 25 FIAL 8.13 5.85 18.58 6.50 17.88 17.83 9.75 4.94 12.25 7.15 4.88 4.55 7.54 15.60 6.50 11.38 13.00 11.05 11.22 11.70 7.15 14.45 13.00 6.76 10.40 4.63 6.76 15.18 14.72 9. 7.15 6.50 10.08 6.83 11.70 15 16 16 14 16 14 14 14 14 14 18 14 15 20 16 15 19 14 14 19 19 15 16 21 16 14 14 14 14 14 13 19 14 14 14 1987 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 138 27 2 13 24 13 15 12 24 43 13 16 24 4 24 45 20 21 2 4 30 32 13 17 26 9 8 1 32 36 20 27 19 19 38 41 3 13.33 4.36 17.49 6.30 34.18 14 16 19 19 18 20
271 16 12 9 9 20 15 8 | mm-| P||| C. 14 21 13 14 | | g3田阳 | 38 10 16 32 2 28 3 8 44 12 8 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 |||| 20.80 6.83 4.55 5.49 3.90 5.20 13.00 6.50 20.80 18.18 17.24 7.93 4.88 11.70 12.29 7.15 11.61 8.13 12.68 8.75 10.12 3.71 4.36 25.98 11.05 12.68 19.50 10.40 14.63 4 24 1 42 3 32 22 18 19 12 42 34 29 8 13 10 22 10 25 11 12 35 14 16 44 13 8 13 18 18 6 37 2 23 1 10 23 8 13 14 14 14 16 14 12 19 15 14 13 14 14 13 14 14 14 14 14 14 18 14 14 15 8.56 57.85 19.50 14.63 9.10 13.00 18.89 26.00 29.25 4.74 13.81 32.48 7.80 24.70 17.16 29.25 19.50 8.95 15.40 20.99 18.14 17.11 6.89 5.85 13.00 13.00 13.00 12.19 7.54 23.22 1.30 || co 14 16 14 19 14 16 19 21 18 14 14 21 19 21 19 19 19 20 14 16 21 14 14 14 21 12 19 19 19 15 14 n | ao 12.55 6.78 9.10 15.81 6.83 13.42 4.36 10.01 11.93 10.96 5.20 5.37 3.90 9.79 13.69 6.50 19.54 14.63 8.13 4.55 8.91 16.25 15.60 7.80 12.35 5.33 13.56 10.00 272 273 274 275 276 277 278 279 280 281 282 283 285 286 287 288 289 290 291 292 293 294 295 296 297 298 300 19 15 19 15 14 14 14 14 14 16 16 14 14 20 19 14 14 15 14 15 14 14 16 14 187 188 189 190 191 192 193 194 195 196 197 198 199 200 26 16 14 38 14 7 13 20 7 26 14 36 24 28 1 12 39 24 32 4 25 8 16 5 31 25 15 15 19 9 33 19 14
ID 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 Wage 13.00 10.40 8.95 7.22 9.75 11.61 11.70 4.55 7.51 32.50 8.91 8.45 4.88 4.55 5.85 5.43 16.90 5.18 9.75 17.06 5.20 5.14 16.90 11.70 5.92 12.35 5.85 11.38 13.00 23.40 32.48 15.67 28.60 11.38 Education 12 14 16 13 13 9 19 12 19 16 16 13 14 10 13 16 14 16 14 14 14 14 13 14 9 10 8 13 15 21 20 19 16 14 Experience ID 25 501 15 502 10 503 45 504 3 505 47 506 6 507 33 508 3 509 4 510 34 511 39 512 17 513 47 514 2 515 24 516 25 517 6 518 10 519 33 520 12 521 9 522 18 523 10 524 45 525 46 526 14 527 36 528 34 529 15 530 31 531 6 532 15 533 30 534 Wage 16.25 7.53 32.48 5.66 14.63 8.68 10.40 23.61 15.60 11.56 12.35 17.75 15.60 19.50 16.48 9.60 20.23 9.69 8.13 8.13 12.19 29.25 9.75 9.10 7.48 9.98 16.25 20.80 15.33 14.77 7.93 30.23 25.85 20.00 Education Experience 20 13 14 42 20 18 14 3 20 10 19 10 19 17 21 7 19 14 19 22 20 14 19 11 21 23 14 39 19 15 16 15 19 10 14 25 16 12 19 7 20 7 19 17 19 10 20 2 10 34 18 11 18 10 14 12 19 6 21 5 14 33 20 25 14 13 19 33 1812 19
2 436 437 438 439 440 441 442 443 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 28.86 22.43 7.80 10.48 12.02 15.60 13.80 7.43 22.75 19.50 10.12 10.14 13.00 32.48 13.37 19.50 15.60 13.76 7.61 14.59 11.13 18.06 7.43 20.53 9.75 14.63 8.00 17.49 8.13 8.45 15.60 11.05 10.40 7.48 20.45 21 21 20 15 19 16 18 21 19 21 19 20 19 20 18 21 20 19 21 21 16 19 21 21 19 14 19 19 19 14 14 14 21 14 19 8 5 3 17 5 10 33 3 13 12 6 7 14 5 10 11 24 9 12 19 14 17 7 7 22 28 16 16 7 11 11 16 33 21 4
13 14 10 14 29 4 27 3 14 33 38 18 472 473 474 475 476 477 478 479 480 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 12.82 17.57 7.02 8.13 7.15 6.50 8.13 7.48 26.65 9.10 23.40 15.60 26.52 28.86 21.35 11.22 25.20 18.20 13.00 20.74 26.00 13.00 32.48 14.63 29.68 13.26 13.00 18.20 18 21 19 21 19 14 21 14 19 21 19 21 20 21 16 16 19 19 16 20 19 19 19 18 21 20 19 21 3 40 19 4 11 16 22 13 28 10 5 5 5 37 26 4 31 WNW on on