Please upload your answers with interpretations and necessaryexplications for the steps of analysis that you did (using “pdf,”“free office,” or “Word” format).
Please show your codes.
1. The file CEOSAL2.DTA contains data on 177 chief executiveofficers and can be used to examine the effects of firm performanceon CEO salary. You can find description of variables in thetable.
a. Estimate a model relating annual salary to firm sales andmarket value (all variables in log form). Write the results out inequation form.
b. Add profits to the model from part (a). Why can this variablenot be included in logarithmic form? Would you say that these firmperformance variables explain most of the variation in CEOsalaries?
c. Add the variable ceoten to the model in part (b). What is theestimated percentage return for another year of CEO tenure, holdingother factors fixed?
d. Find the sample correlation coefficient between the variableslog(mktval) and profits. Are these variables highly correlated?What does this say about the OLS estimators?
e. Which statistics is better to compare explanatory power ofestimated models?
f. Using available variables please find best model andinterpret the results
- Please Use Rstudio Script Or Rmarkdown For Your Analysis And Clearly Explain Your Steps And Commands Interpret All 1 (132.52 KiB) Viewed 11 times
1161 600 379 651 497 1067 945 1261 503 1094 601 355 49 43 51 55 44 64 59 63 47 64 54 66 1200 72 697 51 1041 63 245 44 817 68 1675 971 609 470 867 71 72 58 60 59 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 0 1 1 1 1 0 0 0 1 1 0 0 1 0 1 0 9 10 9 22 8 7 35 32 4 39 26 39 37 25 21 7 38 31 33 36 20 36 2 10 3 22 6 7 19000 536 8 4800 4 610 7 5 2900 230 7 1200 34 560 37 796 35 1 8200 234 4300 91 135 24 1300 55 10 8 11 7 4 12 24 1 6 14 283 6200 966 23200 48 1100 40 1100 -54 1000 169 1100 351 387 28 614 3900 24 191 623 2100 454 3900 533 477 674 1400 1100 2300 884 7,057037 8,732305 9 23,66864 4,477612 100 64 10,05191 81 6,39693 5,645447 7,003066 100 5,937536 5, 129899 7.003066 81 6,478509 7,003066 6,907755 484 484 -4,90909 6,20859 5,860786 5,958425 64 36 7,977208 6,972606 9,852194 8,268732 49 49 3,231579 6,851185 6,284134 6,434546 1225 7,13966 8,476371 7,649693 1024 3,979167 6,22059 6,413459 6,118097 16 16 1,147541 6.997596 7,972466 8,268732 1521 25 7,931035 6,398595 7,090077 6,278522 676 49 2,833333 5,872118 6,327937 6,167517 1521 64 678 7,090077 6,679599 6,519147 1369 1369 5700 6,546785 9,011889 8,648221 625 1 2.853658 1400 6,947937 8,36637 7,244227 441 121 2,116279 5,501258 4,905275 6,324359 49 49 17,77778 6,705639 7,17012 6,741701 1444 16 4.230769 1200 7,423568 6,51323 7,090077 961 144 17,06231 609 6,878326 7,244227 6,411819 1089 576 4,928571 6,411819 7,003066 6,779922 1296 1 6,272727 6,152733 7,740664 7,696213 400 36 9,130435 6,765039 6,784457 7,313221 1296 196 9,162896 1,428571 4,396985 558 847 8 115 69 69 880 210 2200 81 1500 4 15,58065 16,96113 100
752 246 825 358 1162 270 829 300 1627 1237 540 1798 474 1336 541 129 1700 1750 624 791 1487 54 51 56 50 58 43 56 77 62 63 61 66 40 60 51 66 54 66 61 66 1 51 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 0 0 0 1 1 1 1 0 1 0 1 1 1 1 0 32 4 0 8 4 23 15 24 6 8 14 8 18 4 45 2 6 13 4 21 4 37 9 30 37 1 21 2 31 21 1 4 4 - 3/4 2 4 1600 1 78 1070 0 99 3800 10 150 1 2430 4 0 2700 1 2200 6900 8300 4600 5200 21 5 6800 4500 1400 3 3 2220 0 1224 61,0 0,99 0,69 18,8 1 9926 .452 8571 5238 5238 9048 59 1620 0 1100 3 14 8 2300 0 ,238 193 3200 13 295 5900 458 25 2300 226 1800 28 713 184 1500 483 4700 596 9100 108 6200 549 5600 338 1250 0 117 2000 562 4300 82 1200 28 412 1200 2040 0 1400 1790 0 109 934 -60 487 492. 9762 182 2800 6,62 7,37 8,07 2736 7759 0906 5,50 4.35 6.12 5332 6709 6869 6,71 9,27 8.68 5384 7999 2708 5,88 4,59 7,74 0533 512 0664 7,05 8,24 7,49 7898 2756 5542 5,59 5.01 6,56 8422 0635 9481 6,72 7,69 7,31 022 6213 3221 1024 16 6,29 8.55 1569 6414 7.49 10.0 443 9823 3484 64 64 16 16 529 16 7,30 10,0 7,93 4516 0785 7375 7336 6,93 .305 2343 5285 576 225 5,70 8,83 8.45 2025 676 3783 9276 5317 7,39 9,02 9,11 4493 4011 603 7,12 8,43 8.73 8.13 0444 3811 2305 8.63 1369 0522 36 196 64 4 169 16 1369 81 9.43 441 196 1 6,16 7.90 7.60 324 1207 1007 0903 7,19 8,41 8.36 7435 1833 637 6,29 7.24 7,09 900 16 3419 4227 0077 1 441 169 4,85 4,07 6,02 16 9812 7538 1023 7,43 8,82 9,92 441 8384 4677 329 7,46 9.69 9.79 7371 2766 2556 6,43 7.00 6.83 441 169 6151 3066 9477 6.67 7,74 6,18 3298 0664 8264 9 16 25 961 576 196 64 9 8,72 8.01 459, 155 3214 4238 ,38 1 12,0 625 16,6 6667 2.75 7009 25,2 5253 5,94 7369 18,6 6667 8,36 3636 7 7,18 0723 2,34 7826 10,5 5769 1,39 0947 4,33 3333 12,4 8889 5,85 7143 47,4 5763 17,6 4706 8,64 1975 9,90 9091 2,60 87 0,81 982 8,73 4939
1550 47 401 64 1295 62 449 56 456 56 1142 53 577 64 600 56 649 44 822 60 1080 52 1738 54 581 54 912 54 650 2199 609 1946 552 481 526 ㎡ 63 52 53 73 52 59 45 69 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 ----- 1 1 1 1 1 0 0 0 1 1 0 1 1 0 0 0 0 0 0 1 1 0 0 1 0 471 60 1 0 19 4 8 319 44 30 26 18 4 34 19978 15 25 30 26 83 7,003066 1100 120 57 1300 571 10700 661 37 6,347389 7,166266 9.277999 6,107023 6,493754 5,9428 7,040536 10,23996 3 381 34 1900 26300 1 28000 2 3000 7 11700 336 896 287 5700 6,357842 8,006368 -40 4000 6,39693 17 475 6,475433 77 752 6,71174 1600 6,984716 15400 7,46049 403 6,364751 2400 6,81564 55 388 10700 842 817 6,476973 6300 7,695758 498 6,411819 7,573531 8000 3500 6,313548 6,175867 667 2000 6,265301 7.783224 425 6,154858 5.075174 22 18 14052 9 9 3 37 3 8 8 1 19 408 2600 261 8 5600 567 21 7800 13 15 1 2800 611 4 7 2400 160 2 23 239 40 475 34 484 308 90 106 7 4900 7,34601 670 5,993961 16400 538 6700 6,122493 8,49699 361 9 6,507277 1936 64 9,705036 64 64 6,287858 961 1 8.809863 81 9 10,17732 900 1 8,648221 676 4 9.367344 8,294049 324 49 16 16 6,163315 6,622736 484 400 5.817111 6,79794 5,961005 9,277999 7,377759 324 25 1156 144 9,642123 6,011267 5,998937 361 361 7,863267 7,783224 81 81 5,56452 6,705639 1369 169 8,630522 8,748305 64 64 6,340359 6,2106 225 225 8,961879 8,987197 625 441 7,937375 8,160519 900 1 6,415097 6,50279 676 16 64 49 9 7,600903 6,052089 4 10,90909 9,982487 12,14953 5,597579 8,923884 6.785714 9,566667 -0,34188 5,059524 8,59375 14,17526 7,869159 5,637255 9, 192307 15,32567 8,482142 5,996473 6,205128 11 14,72995 4.416667 4,375
630 622 999 585 1107 57 56 57 52 60 1099 59 425 86 40 2792 350 363 2265 1 1 1 54 1 58 1 63 1 377 45 2: 图 879 63 720 49 950 63 1143 67 1064 58 1253 60 462 58 174 69 474 63 1248 48 1 1 1 1 1 : 1 1 1 1 0 1 1 1 1 1 = 1 | 0 0 35 0 28 1 36 0 17 34 13 11 31 36 35 0 1 0 0 1 1 0 29 1 4 17 10 6 10 13 11 4 1 0 6 6 7 5 9 21 12 27 0 0 23 0 27 1 36 1 23 0 13 0 41 1 21 12 . 14 3 3 5 0 13 4 7 1700 -55 2500 143 159 21 398 1700 33 449 2200 149 1100 8600 182 1800 36 11 534 1000 717 18000 238 1700 672 2600 1800 3500 2600 1400 29 6,44572 7,438384 6,040255 841 1 7,090077 1225 16 5,986452 784 289 6.107023 1296 100 6.43294 7.824046 6,906755 5,068904 6,371612 7,438384 7,009409 7,696213 7,002156 9,059518 7,495542 6,052089 7,003066 289 36 1156 100 169 169 644 888 7,934514 35 46 812 5,857933 880 5,894403 80 1700 18800 6,779922 1296 36 9,841612 1225 36 5,47227 7,090077 49 25 7,438384 8,49699 441 81 212 23 3,583519 6,467699 6.280396 6,788972 121 121 6,907755 6,699501 961 16 6,575076 7,72533 9,798127 57 1200 5,932245 4900 6,778785 1400 6.579251 6.510258 7,244227 144 144 1500 6,856462 7,863267 7,313221 729 196 918 7,041412 7,495542 6,822197 529 9 6,96979 8.160519 7,863267 729 9 7,133296 7,863267 8,216088 1296 25 6,135565 7.244227 6,645091 529 0 5.159055 3.367296 5,966147 169 169 6,161207 7.696213 7.863267 1681 16 7,129298 8,160519 6 2600 3700 769 390 8,89563 441 49 2200 3500 420 1200 56 195 142 50 6 175 2600 423 7300 -3,23529 5,72 13,20755 1,941176 6,772727 2,116279 30,55556 6,554307 4,6 11,1576 9,444445 23,94958 12,47059 3,422619 0,230769 3,111111 5,571429 5,461538 3,571429 20,68966 7,954545 12,08571
110 62 1 348 650 875 58 43 1 1 55 160 61 ㅇ 323 150 55 ㅇ 5 39 459 59 174 9 447 53 m 134 55 0 1 1 57 925 56 1 1 491 43 1 1 375 46 1 1 529 64 1 1 1 0 1 1 1 1 1 0 1 0 1 0 1 1 1 1 1 0 32 12 28 32 4 30 33 26 4 4 6 Im 15 3 26 3 10 42 5 10 1 4 3 12 13 10 4 1 21 2 954 96 13 586 570 0 123 00 530 308 0 637 79 790 665 0 -438 817 11 810 0 785 40 63 330 67 0 877 940 0 561 143 16 140 131 0 120 7,00 6,86 7,09 102 9 0 397 066 007 4 4 4 7 40 140 0 54 599 20 501 240 119 220 0 480 0 7,31 322 1 517 5,77 765 2 6,12 905 140 0 220 0 527 290 0 100 00 521 5,85 6,37 7,24 144 100 220 332 422 2 7 6,47 8,64 6,70 784 25 697 822 563 3 9 6,77 422 4 1 8,57 7,69 546 621 2 3 9,41 9,14 16 735 846 5 5 8,97 8,47 900 461 637 8 1 6,45 6,24 225 9 804 676 9 3 6,66 7,24 108 9 568 422 9 4 7 150 7,37 775 9 102 4 6,82 979 4 | 5 100 8,10 7,69 676 144 167 621 8 3 5,92 6,39 6,21 16 692 526 660 6 6 2 6,10 4,96 6,26 16 255 284 72 9 5 7,20 7,24 7,97 169 100 042 422 246 5 6 7 7,46 8,99 9,21 676 121 679 961 034 9 9 6,19 6,32 6,25 441 4 644 972 575 4 1 8,57 7,78 7,31 176 1 16 16 1 169 10,0 628 9 13,4 812 3 - 7,68 421 5,81 132 1 7,13 008 1 8,41 772 2 9,89 011 5,09 554 1 2,03 030 3 3,33 889 8 11,1 888 1 9,35 714 2 0.49 382 7 9,62 566 9 4,95
9 431 729 128 4 137 3 58 o 50 54 989 40 515 52 57 1 0 8 1 1 130 50 1 1 1 1 1 1 0 1 1 |- 1 1 33 15 36 18 00 32 3 27 Im 3 139 50,9 1 0,55 25,2 25,2 2,48 610 844 597 1 4 2 4 | 3 8 5 1 19 15 에 6,66 233 8 ㅇ 815 36 200 182 0 123 00 143 00 439 130 0 160 0 30 110 51 0 4,15 6 180 130 0 399 431, 077 9 0 550 6,06 260 0 196 00 610 318 8 8 6,59 7,60 167 090 4 3 7,15 9,41 773 735 5 5 236 7,22 00 475 3 582 6,89 889 527 322 160 0 696 5,55 8 322 4 1 108 991 9 8 7,86 225 9 326 7 9,88 102 9 328 4 5 9,56 10,0 129 64 801 69 6 5 6,08 6,36 324 25 6,70 6,30 669 449 647 4 009 7 9 6,24 7,00 6,79 729 416 306 7 6 7,17 7,49 088 554 8 2 9 6,97 7,48 7,74 925 308 471 9 7,37 361 775 9 9 1 225 718, 72,3 662 246 3 8 833 3 4,41 717 8 9,1 10,5 691 1 11,1 888 1 6,83 371 3 4,63 636 4 7,22 222 2 7,52 936 1
849 46 100 61 1 1 1 1 679 62 567 56 559 54 704 52 308 45 1392 48 389 55 790 69 396 80 398 54 707 46 984 60 410 55 1095 60 694 61 834 61 1630 39 493 55 1 625 57 0 483 52 1 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 0 1 1 1 0 1 0 1 1 1 1 1 1 1 1 1 4900 597 2100 50 210 6 4800 0 29 4 0 45 37 0 58 28 4 6 7 36 20 24 26 0 1 24 26 40 6 31 10 22 6 14 6 2 6 14 4 1 4 33 5 35 19 32 0 8 8 4 1 36 9 18 538 2700 14 478 1200 513 633 130 1500 501 27600 4200 7600 227 1300 1400 1000 36 394 -463 7,244227 1600 -9.44898 576 576 6,69145 9,220291 676 676 14,59259 36 7,438384 961 100 4 36 10,88777 0,619048 196 7,649693 6,530878 484 3,912023 6,805723 36 5,347107 7,549609 196 8,476371 7,003066 36 5,963579 6,169611 6,040255 841 16 6,672033 7,090077 8,070906 2025 1369 36 5,981414 6,240276 6,870053 3364 784 5,986452 6,45047 7,495542 16 16 1200 36 1 1700 590 17100 1000 6,561031 4,867535 7,090077 6,891626 7,313221 7,438384 49 16 6.016157 6,216606 6.380123 1296 400 6,998509 10,22557 9.746834 1089 25 6,542472 8,34284 6.907755 1225 361 6,726233 8.935904 822 7,396335 834 6,200509 979 6,437752 35 548 6,180017 5300 0 80 8.575462 1024 5,42495 6,71174 64 7,17012 6,726233 7,244227 6,886532 1296 6,907755 6,306275 324 196 16 87 65 13 8 473 10100 1400 1700 69 26 135 34 1400 75 364 27 39 51 38 420 140 3200 53 6,744059 4,60517 6,287858 6,159095 7,901007 8,49699 6,340359 6,391917 6,520621 686 903 6,326149 6.556778 1900 5,7301 1100 7,238497 963 1800 16 18.57143 1,0625 7,949791 11,66667 10.33138 10,90047 20 9 6.786427 5,072464 1.785714 4,789474 64 11.89427 1 6,153846 81 6,214286 3,5
733 60 2102 67 853 58 1 345 54 1 800 800 57 764 55 59 1 40 1 0 0 1 0 1 1 1 806 310 310 1119 61 1287 59 1201 J5 1 0 1 1 0 1 7 1 1 1 ✔ 1 1 31 1170 57 1 ! 880 62 1 0 9 1091 33 1 1100 65 1 0 U 650 53 1 607 38 1 1133 63 1 0 50 393 58 1 605 53 1 1444 59 1 1033 1142 50 0 1 1 2 3 1 a 1 1 O 0 8 8 41 20 34 34 33 12 1 1 1 1 62 1 18 18 34 4 4 9 9 9 18 5 2 7 0 J 36 12 9 36 16 O 2 30 11 9 3 16 2 3 3000 1 2400 9 2500 3 4700 9 6 9 4 3 9 6 4 2 1 347 10300 1 3 818 994 1800 1100 1900 5300 181 18 1700 563 1482 231 870 285 33 56 32 145 222 208 229 36 257 3900 60 1300 71 1200 2700 2700 778 6,597146 45400 7,650645 6.74876 5,843544 411 781 479 2100 -271 1300 544 557 599 686 956 422 505 6204 401 10700 5400 2600 40 38 37 40 30 5600 3000 4000 6,684612 6,638568 6,692084 5,736572 7,020191 7,160069 7,064759 5,849325 9,2399 6,706862 6,901737 6,660575 1089 7,495542 6,1717 144 961 7,003066 7,649693 8,006368 8,268732 7,783224 7,824046 7,090077 8.455317 0,499911 7,901007 7,549609 6,656726 64 64 10,72327 1681 400 6,018593 1156 1156 6,779922 Over 6,99485 7,003066 1000000 6,476973 Toron 6,408529 7.032624 8,575462 0 5,198497 5, 196497 6,33328 0,99920 7,301148 1440470 5,442418 6.768493 6.530878 5.97381 5,652489 6,862758 1296 6,405229 6,045005 6.224558 256 7,275172 8,732949 9,277999 4 478 7300 6,940222 8,594154 166 2200 7,040536 7,863267 8,89563 900 7,696213 121 9 7,17012 324 1156 8,630522 8,294049 7,17012 6,298949 GORPAF 6,322565 16 81 1296 81 324 205000 6,395262 25 49 81 0 81 256 a 9 1 81 9 9 9 144 81 36 16 9 81 36 16 5,18732 16,50485 4,03423 5,633803 1,777778 13,18182 8,566667 2,5 2,84 4,723404 10,94737 4,320755 020799 19,8895 9,0095 -48,135 COCOFF 2,699055 4,090000 16,45022 4,252873 14,03509 7,109005 4 6,463572 8,851851 1 9 6,384615
537 693 439 358 1276 873 537 713 1350 1268 465 693 369 381 467 559 218 264 185 387 2220 445 46 42 57 64 64 41 57 57 68 47 64 46 49 54 49 57 57 63 58 71 63 69 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 。。 1 1 1 1 0 1 1 1 0 1 1 1 0 0 1 1 0 37835 20 17 26 43 41 2 35 12 35 12 5 30 31 7 20 4 30 13 34 33 2 38 32 18 23 333333238. 42 39 20 12 12 11 17 2 1 25 4 3 3 1 2 。 16 5 3 1 13 18 0 1200 1400 2600 584 635 149 11400 1600 3300 1100 2400 2200 65 2700 513 605 504 334 766 432 277 249 17 206 280 45 52 21 210 55 92 47 326 44 -132 386 49 56 41 43 49 28 -80 31 669 6,285998 7,090077 6,505784 3000 6,54103 7,244227 8,006368 3800 6,084499 7,863267 8,242756 423 5,880533 6,369901 6,047372 1300 7,151485 6,453625 7,17012 567 6,771935 5,003946 6,340359 4800 6,285998 9,341369 8,476371 1300 6,569481 7,377759 7,17012 2100 7,20786 8,101678 7,649693 2500 7,145196 7,003066 7,824046 2400 6,142037 7,783224 7,783224 533 6,54103 7,696213 6,278522 1200 5,910797 4,174387 7,090077 4500 5,9428 7,901007 8,411833 534 6,146329 6,240276 6,280396 653 6,326149 6,405229 6,481577 421 5,384495 6,222576 6,042633 480 5,575949 5,811141 6,173786 560 5,220356 6,641182 6,327937 477 5,958425 6,068426 6,167517 540 7,705263 5,624018 6,291569 828 6,098074 5,517453 6,719013 400 289 676 1849 1681 4 1225 144 25 400 961 49 16 900 169 1156 1089 1764 1521 1024 324 529 400 1,416667 144 14,71429 144 10,76923 121 7,70548 289 8,188976 4 14,09396 1 1,842105 3,4375 4 25 2,787879 16 4,272727 9 13,58333 9 2 1 -203,077 4 14,2963 0 9,551657 256 9,256198 25 8,134921 9 12,87425 1 6,396867 169 6,481482 324 -28,8809 0 12,4498