Answer Happy

plz solve all the questions in excel and show the details of the excel formula
1. (2pts) Suppose that the research question that you ask is: "How the total years of schooling influence the earnings?" If you were asked to run a regression in order to answer this question, what would be your dependent and independent variables? Dependent Independent 2.(6pts) Do regression anlaysis and show the regression equation Display the trend line on the scatter plot. 3. (4pts) Interpret the intercept and slope coefficient. Do they make sense? - 4. What hypotheses would you set up to test the significance of the slope coefficient at 5% significance level (explain also in words what you test) Use both p-value method and Critical value method to conclude. State the corresponding rejection rules. 3D (2pts) State the hypotheses 1) (2pts) Compute the cirtical value at significance level of 0.05 1 2) (3pts) Critical value method: 3 iv) (3pts) P value method: 5 6 7 8 5. (2pts) Interpret the coofficient of determinantion (R-squre) 9 ID EARNINGS EDUC EXP 0 2.28 0 1.77 20 23.55769 2 9 MALE OMN 1 MAX 8

1 1 CSIS 12000 10.00 1200 38.60 1 $566 1 t IT S s 16289 12 4058 1 002 1 321 ore 263 SI 955+ CELE 1 95 T E 13 570 19986 13 BESN 219 STONE 21 BEST 9.50 7189 1 OT 1 T 1 T 1 1 2567 3745 12.00 2017.5678 12/20 18.5 1 1 BETE LLL 01 13 PAS ber SE S 1677 1360 11.08 12.10 1 COS 1 1 007 2658 1246 Lett 1 1 1 1 SOCO 1 1 1413 3070 2776 VISI 3+ LOE titt 003 001 SELE 1 34 103071 GESC 12. DO 1527 1 1 1 00 ST BOT 22 18.09615 17475 TED 2336 25 2167300 1973 SI SOCE TE 1200 1 1 1 1 2235 1 1 1 1 10. 16 2016 ett 003 08 NOCH CBZ ME co 1 13.00 16:30 1911 1 1 1 10.3 POCO | CD: TE 19 10061 Co to 21.00 20.94 1 1 1 1 1 1 1 I 1 3700 4728 2380 T72 4308 5203 3594 2004 5266 1050 09 21.11 19 11 21154 9. 52 09 1 1 1 1 15.20 SEST 23 029 NOCE NO OP TW 133 1 21 14 1 1 1 3420751 321 301 CITE esos ! ett COST 0001 : Osts ASI 11.15 1 14 16 3461 tt ta 10:0 1 1 1593 1350 TONTE 3630 1 123 D3 0972 2015 34 21 96154 34.15 0950 1 1 12012 15.39 973 CET TET 1 1 200395 10.00 25.00 12 10 5375 11754 LOC 1211 1 I 1 1 964 ! 1 1 1 1 Moter S: Seco 41 1046 1855 OP 06 CE 416 0642 1 I 1 2215 33.33 2013 0133 1956 00 tort TH 1 1 1996 1908 titt DELS : TE: 9021 27.00 12.45 37. TO 4022 1 128Z 1 6225 10 73 2302 10 17.5 EXP MALE EDUC EARNINGS

1 53848 Sant 92 TE 2.23 24 26 1 1 19.05769 06 2015 3374 3420 1: 2200732 1 118 1310.65385 12 360 Het LED 1 1 COT 00% 5051S BOCH 1000 1996 0 BE 1 1 1 1410 234 TATE 0097 2500 1330 24 18 26903 25 1 1 2 1970 SOCO SET BT2 000 LO 19.40 22.04 111 5210 14 20 13 36 50 15. 1 4114 008 1 1 1 1 1 34 19 51903 2016054 119.56539 260 0 1 LG! 97901 1961 MT ott 319 32077 575 2009 140 4.36 1. STT ! 40 ICERE 1850 TE 1 CMT 16 11 T: 3803 113 1 1 1 1 2 00 230 NOCH 96 99606 0 34. 15. 56700 3421 (6 1754 3322 33 30.65305 12. 12 54 1 106) 1 000 03610 61 19T 4607 1 1 1 1 1 SEX SCES 12/28 67200 11.40 OSI : 2774 24 150 LO tos 1 1 ICE DERDE GESTI 2.21 1326 18.00 BREZ 4787 2346 1 1 1 SES 28.04 1928846 LSE SIST DETE ALTE 61 230 25.00 41.00 IS196216 16 2010 2010 13964 21.00 61 998831 980079 1087 OCES 1 1 1 1 23.70 20.50 47.00 3402 4B: 30.2592 38 94231 115 2017 10 IRON 90 2010 1 1 15196 05 11 :01 OCT 1980 1 14:54 13 17300 1700 GOST 1250 11.96 27.80 1295 4329 1 1 1 CD 0% 2.673071 21.21 2011 10131 CLETE THE 2:03 ICIH CONE 6TE 28.33 Tent 2 (003 97 1 15.25941 2009 2713 5282 3978 2372 3503 9900 63610 0095 0 1 001 001 ATT

207 : 123.93 39.31 3231 2009 2321154 15.5 2014 1131 1990 7.50 2020 213 1745 3171 1560 2391 43: 2673 5500 12100 2544 2544 783 12.06.2008 15.76046 1 1 1 1 1 1 1 1 COPHE : 215 216 217 218 219 220 : 20. 26.32 36.61 24.02 12.00 16.00 11:20 25.4 11 10 12 00 2417 42300 12210046 26204231 317.67300 2 19.05355 4.2004 : 1 4161 1 1 221 CHE 1 30 4033 11125 5252 12117263 20 44231 CBR 2011 1 1 1 1 1 1 1 1 222 223 224 225 226 227 228 229 230 231 232 233 22T 1 4778 12010 30: 2200 LOCE 22,70 3.15 1115 1931 12 10.75 2013071 31 13 9 517031 1211736823 3116 42311 22.03846 9:15 1 1 1 1 1 234 91 ICON 1 2815 3050 33 4199 4362 2521 4470 3410 31 8.75 121 4615 CEID BEST 1 1 1 1 TEST 1 1031 23.7690 1020 2010 13001 25.9077 1711558461 34 11 01 21154 24 25 1021031 1 1 1 1 9 113 116 204 15. 25.50 12.50 35.3 1 20.30 20.60 55.00 11.30 36.32 13.00 3.30 22 0 39.00 12.00 32.6 21.30 1400 32 8.00 13.00 5030 40.00 11.44 150 36.61 34.48 2025 2176 3925 3373 2790 250 7189 264 4042 2335 5241 1505 5446 100 1 1 1 1 T SED SE L206 TE 1 1 04 2000 1 1 1 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 1 619 BE 4293 2163 565 1 3354 13 22.6.1998 16 314.4331 10.154 131275336 110 T20 6.25 34 30.590 3319980771 131113951 10 15 NO 1113 231 2012 49077 20 15.51 1336730 22334015 22.15 61539 1 EL 153 12190905 35118 98077 23 2059231 64.10 5.15 1 1 1 1 1 1 1 1 1 1 1 3776 9345 3390 3590 1331 2540 305 3520 2624 11.11 12.10 1 1 1 15.00 20.76 11.30 1 DELE 2600 37.50 2200 1 3125 1 2016 333 121.15095 114015 302 34605 12 20.09231 131211599 53.00 24. 29.70 TEST : 2991

c 0 F 279 2 2045 200 400 . & 34 E 14 17.5 36 19.11539 139.788462 16 10.50 1 ! 10 1 1 4243 230 1 155 16 2170 2001 G 132213461 2011.0017 12 16 12 20 17300 122235461 1520 15305 1 1 ! 1 1300 CM DET: 3401 GRLOS CIO 1 1 3708 3567 4543 26.730700 22.63480 1319 69615 1223.1931 150 2009 HISE 360 1 1 1 1 1 1 1 ! C 12 3585 19 43: 330: 113 333 14 11:13 14 3. 1 1 12 20.069 12.00 16 17.39461 122263461 1920.61599 18. 21254 1222.0073 14 19.57692 20 4231 130253848 2016.15 1622 19231 1 1 1 1 370 DES 1 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 2000 6111 TESS 1 1 02610 61 1 2016 11025 IT 1951 ! 1 1 265 009 1 11 1 11 1 . 2100 2005 330: 1163 2003 2653 50 0 20 + 1 TECH 55.5 : 1 1 1220.0009 21.51123 1419 29923 1615.32692 1913.67300 1321.92308 142321154 16 12.92300 1322ONIS 191.780462 1318. 17300 12 19.99005 342019831 11.15 15 16.69231 13.20 9 19.78846 16 14.300 1418.96154 12 11 23 18 20.63461 111.9154 1220.0005 12 21 71154 10 16.000 12 20.13461 1222022 122002692 3893 26. + 1 1 2530 $30 5540 700 5 957 1 1 SZE 250 2764 1.00 1 ! 1 1 1 111 250 103 BOLT 150 1 2500 1980 5043 1 1 LETZ LOOP 20 0 329 330 331 332 333 334 335 3.36 337 338 339 340 341 342 343 344 345 346 347 348 349 2015 0 :4 ELS 0 345 21.30 0 0 2:58 0 2.0 2016 2017 2011 42300 2015.95154 1 19.09615 1810 12 15.32690 1317.6515 136789231 30 14 09 111. HIS 1212302093 12 10 000 13 22.30 0 360 474 O 13 3810 SIN 0 10 D 21 JOSE 3.00

n D D F 351 LISTS 15.00 E 24 1014578 0 0 0 006 94.95 GEST T 0 2940 3754 5343 3116 12000 4600 1334 4:02 007 0 o 0 0 11.00 20.00 D 10.16 DO 0 D 10 21.0 Tess 3.2570 0 D 0 D 324 2359 400 3544 2493 3513 2411 2066 185 15.95 15 136. 115005 0 D D D D SSIT 2013 30. 20.00 16 . 2:03 0 1997 20.54 20.5 10.00 454 23 5:35 2400 9.15 D 2420 928 CONO SIS 0 0 o 0 : 20 43 = 10TH LOC 0 14 11:30 2.90 0 o TET 11790 2307 1607 6100 4999 3033 1902 11870 1751 3370 3790 30 16 12.35 24.15.1 361 15.6535 D 0 D 0 0 GRESS SITE 36.00 34 9.30) 245 17:30 1871 34.50 20 35 221.28846 151 216 51903 12.5 0 0 0 0 4740 3532 D . 0 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 390 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 554: 003 2014 7370 1325 221154 0 D 0 2570 1500 2340 26.00 10.30 23.00 24.00 11 SINNET 0 BCS 0 D 6931 o 0 3187 2552 0 2013 1.50 DELE 22154 ఒకరు ఉందం SNIS 30 2010 1571154 1017558 31 13.1353 0 0 0 o 327 4156 2676 6953 25+ 11915 7.00 8.25 11 50 0 Stut o 0 8.00 571 33.142953 100 17504 0 D 4T6 SOCO 0 TOTE Tes 15.11 11.70 26.43 113 2011 D 3000 2023 4641 1951 241835 15.2003 117 1541 12 2013 0 0 e 15.30 21.00 + 1815 DNSSE SU O D D 0 CB 24.50154 10.00 o D 854 5043 3:56 355 2.30 S 1300 12 2925 19 14/11 55 0 0 0 INC 1234 11 2.1

B D F C 15.13 3 B06LT 1 423 0951 20611 104 123071 O R! 97 18tt LENT OTETT 22. 2.50 38.26 100 131 026 的 082 1745 31.25 17.70 121236151 17|11 1154 92271154 123.33923 0722 LEP 1370 THE 72.15 16.34 18.05 1962 ICBET I 5351 2:30 18 13. 1993: BBIT 16.25 WOS C2619 C 11.22 432 433 434 435 436 437 438 439 440 441 442 443 424 445 466 447 12 1 003 . 30 10. 1211.69231 126.096154 12/2007 1811 71154 122141011 2011 12. 41.82 18.00 0752 2000 ΕΣ 0261 EST 10.00 919006151 ICH IST 11750 6 12 18.23001 LETE 11.00 19 T 1 st DOES 00 877 943 15.11 13 16 09461 1223 0384 125.000 449 HET 00 OS? 11.60 19 Bar 3401 249 E 1 59 12200013 17 12 78923 10/17 21154 10 19.84615 STE 10.50 6.93 5977 20 36958 2118 1221 82300 BE TET IS 160 DO'S LE BT 50 001 2014 0904 451 452 453 454 455 456 457 458 459 460 461 462 463 464 455 466 467 468 11.00 20.50 199 Ster HOCO 19798 2110 2006 119 2254 13] 2000 89'11 10 10 LT 2008 lor 1293 5555 1219 1.25 4.75 13.42 12121.43017 16. 12 22. 0010 1955 ETTE L200 TS Ct TE 13.50 12115 32093 695 323 A6 Ott 2004 00 DE BE 1619.95154 3516.63460 12005 3287 14.00 2.00 21.50 ICH PIER 1315 470 471 472 473 474 475 475 477 478 479 480 481 1816 TO 1601 8086 20 2011 16118 00700 16.25 16.65 23. 3331 27 SE IT BE SOOS Slot SASTO DO ESBIE 055 Dott 1223. 07692 1317.5615 1215 096154 287 31764 5272 9.20 7.55 HE ST96 BOCHT 10 11 483 434 485 486 SEM 12.00 10.30 11.92 16.50 2019 288462 12 17 5193 1221 7804 971 3805 287 12052 4BB 489 490 4662 2933 4465 4:01 LOZ 30 31 1222.00071 1012.2003 12 15 180 14 12.90395 167 23.25 16.12 | 492 4041 1861 5.5 PEED €67 05 124 412301 12.12.2008 05

C C D D F F 495 2014 1.40 310 5066 3200 5578 150 1240 3350 6.15 20.10 9.00 ED 14.00 1048 E 910.42308 2015.73071 1915.01923 1545154 12 16.92300 12120.23077 130.004615 14 13 596151 12 15 29077 322273021 17 14.34615 16 19.5510 35 12.00 20 13 18 12.25 131 169231 1311442300 2015. 69231 12 18.40395 14 153202 12115 21154 200 1992 1666 2959 1422 6557 21.11 2.65 10.01 11.52 1492 24. 47 11.50 89.12 33.17 9.15 9.30 9.30 7.50 15.14 9.00 9.70 29.00 1030 12:20 503 504 SOS 506 SOZ 500 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 332 1769 11850 1905 9198118 009 3741 2565 000 1316 44231 1220 23077 2015 57792 13 19.73023 34 19 OMIS 1513.51923 35 15 13461 1020.7845 120.000 SE 4037 5100 2.777 1600 3730 5225 14 50 14.00 7.00 11.83 19.00 31.03 6.00 2.35 18.00 12.30 12.00 16.03 16.66 13.00 12.50 S199119 011 EES 196 2452 11808 2:26 354 12083 910 411 4330 4 200 *3301 5282 4524 3312 104 200 615 3224 12120 3540 2070 21.03 24.18 14.90 3.30 1.26 12.79 4.15 13. 23.00 21.30 1.70 14. 19.00 20.80 1222305 17 14 01 12 23.5570 15 16 71164 216.11539 18 19 20 12 13 730731 12 12.98017 150.50229 209.800 12/10.66506 121667300 30 20.00 131095 1219.76903 16 16.2007 132213401 10 20.000 31 9.70462 15 18 12 17.44231 13 15.6153 13 175 16 15 13 2017 141116923 13 19 71154 534 535 536 537 538 539 540 541 542 543 544 545 545 547 548 569 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 560 STEZ 10.00 1465 3.50 1988 SITT 5990 1431 460 5052 2999 1252 2900 5438 4992 3367 1656 3400 4778 3040 . 21.30 14.30 11.9 11.22 39 25 15.52 17.30 15.00 11.87 10.50 3.00 17.65 8.00 10 16.84615 12 18 69231 113.2003 26 10.25 12122 09615 2012.15 12 17.89481 SIMONA 12 20.26923 32 12.5 1215.23071 329.00 NO

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 3273 1410 5536 5107 3802 5188 5674 4220 3738 2622 608 1071 1116 4632 4292 3744 2016 756 5387 3741 5404 4149 4878 304 952 4711 611 3964 1598 810 2408 3096 5085 3771 3900 4954 4844 244 2405 11929 3912 8.00 22.11 53.06 62.50 10.50 17.18 18.04 2.28 6.75 14.17 17.52 6.75 25.00 27. 50 17.57 21. 10 20.63 11. 28 30.00 10.25 16.82 20.01 33. 65 9.52 23.00 17.50 21. 50 13.00 13.00 36.24 16. 53 10.00 5. 44 13. 42 13.62 22.02 12.50 7.00 16.95 28.04 23.5 2.28 129.980769 12 21. 76923 128. 730 769 19 13. 25 13120.42308 16 16.82692 132. 173077 12 15.03846 1215.01923 1910.59615 16 13.90385 12/8 865385 14 14 96154 16 15.23077 14 17.03846 13 21.17308 17 10.30769 12 13.76923 16 12.71154 12 20.90385 13 18.46154 12 22.96154 18 10.11539 13 13.53846 12 18.44231 12 16.15385 16 19.32692 16 16. 17308 14/12.05769 16 19.51923 12 17.40385 13 6.403846 1218. 92308 1614.11539 1218.46154 18 12.63461 14 13. 13461 12 18.05769 167. 134615 207. 019231 1520.21154 0.00 1.77 20 23.55769 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 1

11 B D E F G Н. 1 9 1. (2pts) Suppose that the research question that you ask is: "How the total years of schooling influence the earnings?" 10 if you were asked to run a regression in order to answer this question, what would be your dependent and independent variables? 12 Dependent Independent 13 14 2. (6pts) Do regression anlaysis and show the regression equation Display the trend line on the scatter plot. 15 3. (4pts) Interpret the intercept and slope coefficient. Do they make sense? 16 4. What hypotheses would you set up to test the significance of the slope coefficient at 5% significance level (explain also in words what you tes 17 Use both p-value method and Critical value method to conclude State the corresponding rejection rules. 18 D) (2pts) State the hypotheses 19 20 ) (2pts) Compute the cirtical value at significance level of 0.05 22 ) (3pts) Critical value method: 23 24 iv) (3pts) P-value method: 25 26 27 28 5. (2pts) Interpret the coefficient of determinantion (R-squre) 21

D E H 1 1 ) 1 N O a S 4 1 2 3 P 31.25 6,15 1 1 1 610 1 1 1 1 1 1 1 1 1 5 K 22.3 12.73 19. 23,70 5.15 10,65 11.25 11. 2.00 14.00 9 A 301 57.69 37.79 1619 27.00 14.00 38.81 22.18 12.30 11.90 27.10 13.30 25.00 10.00 81.82 21.15 0 1 1 1 1 1 1 1 1 1 1 F 12.00 10,00 9.85 12.00 13.50 36.00 32.69 H.24 20.00 35.31 36.33 21. 31.25 10 27.0 1 1 1 1 1 / 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 L M 17 15. 19231 12 10,75 20 7. 423077 IG 18.42308 129.519231 12 17.26923 1 16.94231 13 19.03846 10 16 14 10.94231 18 8.75 12 21.89615 12 20.01923 17.019231 12 23.07092 13 20.80769 20 IR 13461 1 B C 19 17.57692 111. 17308 18 13.70 13 21.57694 13 21.82692 1220.38461 16 13, 01923 12 19 12 22 40385 14 16.51923 19 10.96154 12 6.692307 12 21.30769 122003846 1916,88461 14 15.03846 14 21,96164 15 20.76 209331 14226923 16 16.38461 1921.11539 132136530 120.78840 12 22. 07692 11330760 12 19.67308 14 15.25 1911.71184 1123, 01923 13 1419233 13 19. 13461 12 1 1 1 1 1 1 1 1 1 1 1 1 1 G 12 21.65385 1220,61539 920.68077 12 20.61539 11 21.01923 16 12.03846 198.230709 16 15. 28846 13 19. 20923 181413861 12 23.36539 12 23. 13061 18 9.6730771 12 21. 70923 12 22.96156 1921. 11539 121 13. 1730 16 14.06154 15 12.96154 16 17. 07099 18 15.23077 1918, 9231 12020923 16 17.10388 16 21.28816 13 19.75 18 16.70923 19 17.96154 12 17.78 12 1919.28846 16 19.85618 12 22.78866 1 WE 2.65 10. 11.53 14.93 2. 19.50 0.13 33.17 9.75 9.30 2.8 7.50 15.10 2.00 2.70 22.00 R 10 15.73077 IS 15.01923 15.596154 13 16.92305 12 20.23077 15 9.884615 14 13.59615 13 15.33077 13 22.7307 11 14.34613 16 19.55709 15 12. 07692 20 13 15 12.28 121.709231 13 14.49308 16 15.09231 12 18.10385 14 15.3269 1218, 2118 18.3615 13 10.4231 1920.23077 16 18.5703 13 19.73071 14 19.09615 17.95 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 1 1 L2086'S! SHOP 1 1 1 1 ! 1 1 28.80 2.61 12.50 1693 333 16.7 21. 28.84 16.71 36 16.30 15.50 12.50 36.93 21.93 10.50 20. 55.91 31.0 16.93 18.00 15.30 23.07 30.00 12.00 32 21.30 34.00 13.10 1.00 13.00 50.10 40.00 17.40 1 12. 16.15 2.0 2074 19.00 17,00 20. 33.70 12. 20.00 71.23 47.00 00 1 1 1 1 1 1 1 1 1 . 1 1 1 17 18.8861 14 17.861 12 18.71154 120.3861 132109231 13 18.07092 18 11.980771 13 22. 07692 14 22.75 15 14.44231 10.96154 19 176535 10 11 663 17 22.26923 18 6.25 1 3619 EIS 90 1 1 1 1 1 1 1 1 1 1 L 14.34 14.00 7.00 11. 10.00 32.00 6.00 2635 18.00 12.30 29. 61 25.76 21.11 23.60 20.94 21.00 ! 0 15 15. 13461 14 20.78816 121 89079 16 16.50615 13 22.40385 17 14.30769 0 1 26.04 13. 21 1 1 1 0

4 D E H ! 1 1 N O 0 Q S 1 1 1 1 1 A 17.90 1083 15.60 18.00 12.50 25.00 11.39 1 此时诉了昭四山 1 1 1 P 12.00 16.02 16.60 13.00 12.50 2. ER 21.63 1 I 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 1 G H 17 17.11539 922. 07692 12 13.88461 14 15. 01933 14 22.11539 13 21.6708 16 13.13161 11 19.01923 19 20.618 122. 07692 13 10.90385 14 15.55769 ALOS! F 18.00 18.20 9,25 23.01 21.0 13, 40 15.00 30.00 12.54 T13 39,50 14.21 16,00 11.36 16 3. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 14.25 24.61 17.78 15.00 12.00 R 12 23.55769 15 16.71154 11 16.11539 12 19.28816 12 13.73077 12 12.98077 15 8.876923 30 9.807823 12 18.65385 12 16.67308 16 20.6535 13 18. 10185 12 19. 10 16.23077 13 22. 13461 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 M 14 20.65383 18 19.98077 12 11 13461 14 16.55769 18 13.91231 12 12.48077 16 16.63461 12 13. 67308 121 23,34615 13 15.61539 12 21.61539 12 19.9038 16 18.9077 12 3019231 10 22.98077 13 21.48077 K 8.30 16.66 14.40 8.80 64.10 5.15 34.32 15.63 17.17 12.90 11.27 15.00 2076 17.30 1923 94.00 17.30 2331 0.00 14.80 20.70 6.75 32.00 4.00 SC LLOCENI 41 1 B C 16 16.03846 121 21.92308 16 16.93308 13 17. 19231 10 14.30769 1318, 38401 14 10.75 16 19.49077 12 21.67308 1820.55769 12 18.09615 1418.2846 12 21.36539 14 1.9230771 14 18.16385 14 13.80700 19 10.320921 12 23.0388 128.903846 10 15.61630 14122002 12 18.53846 12 20.82092 16 17.55709 12 18.61539 18 17.14618 16 17.36539 1222.38461 21.82692 22.449311 16 18.44231 12 19.53846 12 19.63461 14. 2.30 2.28 13.79 6.75 17.14 23.00 21.2 2.70 00 SHOP ONI OS 1 1991 1 VRST '18 21 SIOP 6141 6.36 01 UP 100 ICEP ENE 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 100 13.7 18.07 12.10 8.00 12.50 11.99 25.50 27.70 11.00 2010 9.30 22.43 10.16 16.36 12.30 23.07 13.73 58.60 LLOCZ 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 191 117.900 12 21.92108 13.2023 13 20.23077 8.78 13 19.23077 13 29.19461 16 11.16 12 19.36339 16 21.46154 119.51923 12 19.00 16 14.88161 12 7.25 141826923 12 23.30769 10 12 20.38461 11 20.88161 12 14 12303 1 1 1 . STO988898 1 32. 25.0 86.50 IND 1620 60.76 R 12 23.01 19.46 36.00 15.00 1.10 9.00 11.788463 15 IR 25 12 171231 15 10. 0139 1 17. 14 19.28 18 13.23075 14 11.7623 13 19.71184 19 15.8461 16 16 84615 12 18.69231 17 13.26923 10 18.25 12 22.09615 2013. 50615 12 17.88461 161834618 12 20.09231 12 23.11030 14 17.57003 16 19.11539 139.78462 16 18.57002 23.23 12 22. 13461 2011. 18077 12 16.70023 12 20 17305 12 22 38 461 1520 15385 16 13.30769 1 1 1 1 1 1 1 1 1 1 10.00 20. 33.16 16.00 14.65 Sol 11.50 21.30 36.32 11.96 12.32 20.28 11.37 17.30 15.00 1 1 1 1 1 LO 8.12 23.00 3.57 2.95 15,00 19.00 36.71 2015 1 10 1 1 1 0 1 1 1 0

A c D w H H 1 1 r x 1 N N O A 7.00 8.54 56.921 26.50 8.81 1 1 1 1 1 1 1 1 1 1 1 31.00 印础的心門心过得飞对口的四 1 1 1 1 1 1 1 1 1 F 21.63 16.00 13.67 26.44 18.30 24.94 19.23 13.75 5.25 123.90 39.81 113.12 11.13 7:50 I 0 O 1 1 ! 1 1 ! 1 1 1 . 1 1 P 11.87 10,50 5.00 13.60 8.00 12.11 53.00 62.50 10.50 17.18 18.04 2.23 6,25 14.17 17. 6.5 1 0 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 B2 83 84 85 86 87 88 89 90 91 92 93 94 95 95 97 18.53 25.00 64.71 7.50 15.11 21.37 8.43 7.00 7.14 41.86 10.50 31.39 5.65 9.00 8.70 14.00 16.78 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ! 1 1 CSS B 19.78816 14 14.30769 14 18. 96154 12 171231 12 20.63461 16 11.96154 12 20.10385 12 21.71154 10 10.90385 12 20.13461 12 22. 07692 12 20.07692 13 17.48077 10 10.23077 10 11. 42305 1615, 96154 12 19.09615 13 18.70923 13 15 32692 13 17.84615 19 6.709231 10 14 01923 12 11.59616 12 7.307693 12 10.86339 13 22.90385 16 19. 51923 16 14.57692 121 21.6159 13 12.78846 15 16.91231 16 11.18077 13 17.6385 G 19 20.519331 12 10.65385 12 18 31816 14 21.48077 12 19.05769 12 02.88161 12 22.5 13 16.33816 14 10.01923 16 23.21154 19 15.5 18 14. 1931 12 13.88401 12 16.90385 9 15,78846 19 14.69231 14 17.12308 12 21.09816 14 20.14231 12 17.67305 12 19.65385 14 18.28816 13 22.82692 12 17.26923 12) 20. 44231 13 17.28923 13 22.75 19 10.73077 12 23.25 12 12.55769 14 17.55769 17 10 19 21. 17308 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 к 6.15 25.60 15.60 40.00 16.00 17.85 12.01 34.61 11.3 64.90 38. 46 20.83 21.15 17.12 28.80 20.00 30,23 54.27 1754 6.98 12. 20 29.80 48. OT 29,61 30.21 26,51 50.00 37. 11 10.00 16.16 55.55 8.75 20.00 . 1 1 1 1 1 . 1 1 1 1 0 0 M 11 6.730769 12 22.634611 12 19,59615 13 23. 19231 12 21.76923 12 20.820921 12 23.03846 16 17. 38461 12 22.63461 1820.61539 121821154 12 22.990771 1019.67692 0 20.4231 13 22.53846 18 16.96154 16 22.19231 10 19.01923 1200769 11 21.51923 14 19.26923 16 15.32692 19 13. 6730 13 21.92308 1423.21154 10 12.92308 12 22.09615 19 1.788462 11 16.17308 12 19.90385 14 20. 19231 119.153846 13 16.69231 10.78 16.82 16.00 24.03 12.00 16.00 17.30 26.14 11.16 12.00 18.50 11.78 9.50 7.73 12.20 9.25 19.23 15.11 CO 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Q R 17 16.09615 12 20.30923 13 12.55769 12 15.23077 12 9.990769 12 21. 70923 12 8.730769 19 13.25 132042308 16 16.82692 13 2. 173077 12 15.03846 12 15.01928 19 10.59615 16 13.90385 12 8. 865385 14 14.90154 16 15.23077 14 17.03846 13 21 17308 17 10.30769 12 13.70993 10 12. 71154 12 20.90385 11.40154 12 22.96154 TB 10.11539 13 13.53846 12 18.44231 12 16.15385 16 19.32692 16 16. 17308 14 12.05769 0 0 ] 8:00 9.00 15.00 9.00 14.78 6.00 8.00 11.00 20.00 27.50 17,57 21.10 20.63 11.23 30,00 10.25 16.52 20.01 33.65 9.52 23,00 17.50 21.30 13.00 13.00 O 8898 0 0 0 0 OOO 66 0 O

E F H r N o d o 3 s s D 0 0 0 0 K 15.73 18.00 12.00 10.89 15.931 0 0 0 11 0 0 0 O 0 0 0 0 0 А 26.10 10.93 21.70 17:36 6.73 39.60 7.80 15.5 17.71 20.30 20.87 10.00 0 0 1 0 16.50 0 0 0 0 0 R 16 19,51923 12 17.10385 13 6. 1038.16 12 18.92305 16 14.11539 12 18.46154 18 12.63461 14 13. 13461 13 18.05769 16 7.134615 20 7019231 152021154 0 1.24 16.53 10.00 3.40 13.42 13.62 21.03 12.50 7.00 16.95 28.04 23.5 10.70 23.07 12.00 0 0 0 0 DO 0 0 0 0 0 0 0 0 0 1 18+ 1 0 2 O 0 0 0 0 O 0 100 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 16.10 22.78 9.50 38.26 7.50 31.25 17.78 0.25 72.11 16.34 18.00 13.25 16.25 7.15 11.22 7.00 12.36 41.82 18.00 3.23 10.30 9.16 12.00 20.00 15.11 6.00 11.06 12.35 6.50 11.00 B C 16 16. 07692 16 16.76923 16 14.36539 12 19.42308 15 9.384615 16 15 12 6115385 13 13.3 12 21 1 20. 19231 14 20.10385 12 16 50769 O 788462 10 2. 076923 16 11.59615 13 23.28846 15 5. 673077 12 21.23077 1221.21154 12 18.07692 14 15.63461 16 17. 07692 17 18. 19 9.096154 13 15.55769 16 15 12 21.28846 19 18.38461 17 16. 51923 12 12.75 122. 134615 16 14.73077 13 20. 86539 6.25 8.15 14.00 9.75 14.41 11.17 2.90 13.11 0 0 0 0 G H 184.92 0077 14 13.78846 19 21.88661 14 14.92308 127.346154 1 11.71154 12 22.71154 12 1.326923 14 22.30615 113. 19231 18 13. 19231 1916.86539 12 13. 51923 LG 10.90385 12 11 69231 12 6,096154 19 20.99078 18 11 71156 12 21.4077 129.884615 13 19.96231 12 18.28846 12 16.13461 13 16,85961 12 23.03846 125.903846 1918. 46154 12 2099077 IT 12. 70923 1 17.21154 10 19.84615 18 17.82092 12 21.92305 0 0 0 0 0 L M 13 20.82692 13 20 17305 169.288462 12 17.51923 12 21.78846 13 23.23077 12 22.98073 10 17 26923 12 18.78846 14 17.90385 12 23. 19231 124.442307 12 12, 92308 9 10.42308 15 H. 96154 14 19.90385 12 22.9615 16 13.86539 15 11.59615 10 9.25 14 10, 82192 15 15.71154 13 17.55769 14 19.82092 12 13,363539 19 17.32092 13 14.38461 12 11 10385 12 17.53846 12 20.10385 14 18.25 1316.26923 17 17.13461 O 0 0 0 0 D O 0 0 0 16.82 14.50 8.53 7.40 10:20 18.00 24.03 15.73 6.28 2013 7.50 2.52 2.50 7.06 825 11.50 8.00 42 15,3 17. TO 16.41 . 2019 11.6 1. 13.56 7.25 4.75 18.42 2.33 13.50 T 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 10 17 88461 16 17 90385 13 20.78946 16 20.32092 13 21.48077 7 16.75 13 29.80769 15 21.23077 12 16.36539 13 15,32692 13 10.90385 16 19.96151 15 16. 63461 13 14.9201 14 20 10 11.36519 16 18.30769 14 16.25 10 15.53816 1337 4.15 16.00 16.14 9.0 2461 17.30 12.27 14.50 009 0 0 D 0 0 0 0 0 0 0 0 0 0 OSOT 16.00 22.00 23.00 55.28 16.61 214 12.30 0 0 0 EL 00 003 0.97 36,00 19.23 a 0 0 0 0 0

D E H 2. 1 1 O Q S A 39.66 90 0 0 0 1.85 1 0 0 0 0 0 0 ol ol ol ol P 13.62 22.00 12.50 7.00 16.95 28.04 0 R 12 18. 46151 18 12.63461 14 13. 13461 12 18.05769 16 7 134615 207. 019231 15 20.21151 0 15.58 17.71 20.54 20.8T 1000 4.84 6.25 0 F 31.25 17.28 6.25 72,11 16.34 18.00 13.25 16.25 7.15 11. 7.00 0 0 0 0 0 0 0 ol 0 0 22.5 0 ol ol 915 0 1 o 0 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 135 136 O 0 0 0 0 O 0 0 14.00 9.75 1441 11.11 2.90 13 11 14.42 13.37 o B c 18 126 115395 13 13.5 12 21 13 20 19231 14 20.10385 1216, 80769 8.788462 102. 076923 16 11.59615 12 23.28846 155.673077 121 21.23077 1221.21154 12 18.07692 14 15.63461 16 17. 07692 17 15.65385 129. 096154 12 15.55769 16 12 21.28846 18 18.38461 17 16.51923 12 12.76 132. 134618 1 14.73077 13 20. 86530 2018, 21154 10 13 14 15. 46154 12 G H 17 11.71154 12 22.71150 12 3.326923 122.9615 14 13. 19231 18 13. 19231 12 16. 86539 13 13. 1923 16 10.90385 13 11.69231 19 . 096154 12 20.98077 18 11.71151 12 21.48077 12 9.884615 12 19.941231 12 18. 28816 12 16.13161 13 16.88161 12 23.01846 12 3.900846 121816114 12 20.90771 17 12.7023 1 17.21154 10 19.84615 117.820 12 21.92303 13 15.63161 14 14. 1846 125.096150 13 10.34615 0 0 0 0 0 0 0 0 0 0 0 0 K 16.54 10.79 23.07 12.00 23.35 16.80 14.50 8.53 1.40 10.20 18.00 24.00 15.73 6.21 20.83 7.50 22.32 9.50 7.06 8.25 11.50 8.00 1.12 16.37 17.70 16.41 8.33 2019 7.25 15.10 21.00 M 12 23.23077 12 23.98077 16 17.26923 12 15.78846 14 17.90385 1823, 19231 124.113307 12 12.92308 9 10.42308 15 14.9615-4 1419, 90385 12 22.96154 16 13. 86539 15 11 69615 10 9.25 14 10.82692 18 15.71154 13 17.5576 119.82093 13 13. 36539 101732692 13 14.38461 1911. 40085 12 17.63846 12 20.10385 14 1828 12 15 2602 17 17.13461 12 12. 48077 19 9.557093 12 21.84615 41.82 18.00 3.33 10.30 9.46 12.00 20.00 15.11 fi. 00 11.66 12.35 0 0 0 ol 0 1 0 0 15 o 1 O 1 0 11.00 20.50 11.68 36.00 13.86 7.25 4.75 18.421 2.35 1350 6.00 29.24 16.00 1.00 28.50 55.28 16.61 23. 45 12.15 36.33 8.50 13,00 ST 10 17.88461 16 17.90385 13 20.78846 16 20.33692 12 21.48077 16.75 12 22.80769 15 21.23077 12 16.36539 12 15.32692 12/10, 90185 16 19.9615+ 15 16.63461 13 14.91231 14 20 16 11.36639 16 18 80769 14 16.25 10 15.53816 16 16.15385 12 23. 07692 13 17.39615 16.00 16.34 3.80 26.61 17.30 12.77 14.50 0 0 0 0 0 0 19 0 o 0 0 0 O 0 0 0 0 099 ol ol 0 0 10.50 6.97 35.00 0 0 0 10.72 0 0 8.00 ol 0 CO 0 16.00 19.65 10.00 0 ol ol o o O 0 0 0 3.00 9.38 7.5 0 0 0 137

11 B D E F G Н. 1 9 1. (2pts) Suppose that the research question that you ask is: "How the total years of schooling influence the earnings?" 10 if you were asked to run a regression in order to answer this question, what would be your dependent and independent variables? 12 Dependent Independent 13 14 2. (6pts) Do regression anlaysis and show the regression equation Display the trend line on the scatter plot. 15 3. (4pts) Interpret the intercept and slope coefficient. Do they make sense? 16 4. What hypotheses would you set up to test the significance of the slope coefficient at 5% significance level (explain also in words what you tes 17 Use both p-value method and Critical value method to conclude State the corresponding rejection rules. 18 D) (2pts) State the hypotheses 19 20 ) (2pts) Compute the cirtical value at significance level of 0.05 22 ) (3pts) Critical value method: 23 24 iv) (3pts) P-value method: 25 26 27 28 5. (2pts) Interpret the coefficient of determinantion (R-squre) 21