These are the data and the variable :

200 OBSERVATIONS-OBS (COMPANIES) OF FINANCIAL DATA, VARIABLES: MARKET CAPITALIZATION , TOTAL DEBT, LONG-TERM DEBT,SHORT-TERM DEBT, FIXED ASSET, CURRENT ASSETS, CURRENT LIABILITIES, TOTAL ASSETS AND EBIT

INSTRUCTIONS

1. FIRST DELETE THE SEQUENCE OF OBS AS GIVEN BELOW.

1. G1: 101-110

2. G2: 111-120

3. G3: 121-130

4. G4: 131-140

5. G5: 141-150

6. G6: 151-160

7. G7: 161-170

8. G8: 171-180

9. G9: 181-190

10. G10:191-100

11. G11:101-110

12. G12:111-120

13. G13:121-130

2. If you see the number 0 or alphabets like NA in any of the variable columns, you are required to replace them with the numbers that represent average scores of three OBS prior to the 0 or NA cell. Replacement of figures also applies on missing cases.

3. Kindly ensure by now each group to have a complete dataset of 190 OBS after the deletion process.

4. MARKET CAPITALIZATION is taken as a variable to be predicted, the rest are the predictors

5. Create the following variables in the excel sheet: 1. Change Total Assets to Log(Total

   Assets)-LogTA, 2. create a new variable called CR (CR= current assets/current liabilities), 3. Create a new variable called DR (DR= Total Debt/Total Asset), 4. Change Market Capitalization to Log(Market Capitalization)-LogMCAP

6. Focus on LogMCAP, LogTA, CR, DR, EBIT, LogMCAP to be predicted, the rest are predictors for the purpose of completing the assignment.

REQUIRED

1. Perform a descriptive analysis in R , using the variables given in #6 above.

2. Design a structure to show the training data, testing data, and discuss the validation process

   using your dataset.

3. Perform a regression analysis, show the clearly and discuss on the predictive power using

   the forecast figures and coefficients.

4. You may include scatter plots to address the significance of the predictors, OR extend your

   analysis by using other statistical tools that you have learned.

5. Conclude your findings and highlight the main takeaways from your analysis

Should be in R programming by using RStudio, please screenshot the coding and add your explanation.

Thank you

OBS EBIT 308028 1 2 2 3 4 5 5 6 541168 7 8 194029 9 10 11 1 12 13 14 15 16 17 2032218 18 19 10 20 21 22 23 24 25 26 27 28 29 30 31 MARKET CAPITALIZATION TOTAL DEBT LONG-TERM DEBT SHORT-TERM DEBT - TOTAL ASSETS 635074 487982 147092 1257280 953137 643446 486316 157129 1354415 773341 669014 435165 233849 1295791 598279 612245 428189 184056 1266430 535303 560312 346482 213829 1279236 1258039 562343 251033 311309 1475151 582410 320418 134204 186214 1402029 392894 91434 102595 1184017 244981 154761 62132 92629 952211 166404 151298 20439 130859 870359 73956 122426 87101 35325 618889 9691 238879 220463 18416 415094 741354 244406 207453 36953 470886 634539 296941 192694 104247 760009 733710 261646 189954 71692 674720 552861 256567 169349 87218 819188 239657 225395 171205 54190 551449 50147 192548 172022 20526 471499 5983594 1475838 1332572 143266 2433201 3549093 2672870 1901664 771206 3860596 4487696 3418857 2020709 1398148 4791277 12006698 3018250 2560248 458002 6932431 11660402 2668052 2053075 614977 6921638 11814304 3777314 2591475 1185839 8768672 6394233 6192949 5174758 1018191 14438147 5983594 8029554 6259383 1770171 18036840 3549093 13046488 10529341 2517147 22083662 4487696 11523191 6025180 5498011 18827711 909995 7068895 15519056 80688 3147 2678 469 80941 63147 14352 6801 7551 153505 326346 10898 5677 5221 151482 704174 41899 33210 8689 204511 224523 An 30383 14017 315275 92382 94581 80806 13775 275929 80688 80982 64809 16173 266584 63147 65087 51123 13965 240866 326346 90568 17876 72693 862306 704174 103204 1143264 793770 51079 14747 36332 1092675 932633 15503 11414 4089 1131507 966239 11537 7519 4018 1160376 1656928 16001 4584 11417 1549086 1503294 99011 3520 95491 2088012 737482 572793 370796 201997 2603142 669801 435537 370455 65082 2470893 501032 348233 286887 61346 1715785 137756 27669 15584 12085 204273 264416 39882 32834 7048 223062 241282 68515 53947 14568 292050 FIXED ASSET CURRENT ASSETS CURRENT LIABILITIES 119721 817699 390416 322706 111904 778763 495923 306826 1062 680230 466715 317175 34744 581619 492940 277775 21521 543328 476932 337554 56376 545535 642750 546914 46486 528501 364149 14521 502670 364097 209115 -72808 443644 241668 153460 -76337 391083 289519 252381 -116474 334405 214419 127833 42520 319798 95296 58635 77540 305630 163998 74459 102827 302349 457660 211583 21416 299795 374925 171781 32506 400649 418539 225562 -202384 297447 254002 176951 -37607 276382 195117 163551 196471 383801 664838 334709 3008375 811862 1285062 472835 3714989 1061300 1897870 541303 4201167 2160470 800090 593195 4734845 1447637 1036625 553092 5871084 2142644 1793509 374887 8459781 5300157 2326510 -99666 14143868 3156629 3369316 -1922798 16602637 4622156 5069098 762402 9235066 3376423 6648085 Conor 6692694 2641290 8733974 22202 12819 13598 67293 23011 23629 16881 134827 77795 25612 14282 59196 30345 53065 147756 63836 -4242 131488 178648 124587 9769 146380 124431 31029 2874 138255 123109 41639 -17955 117308 119065 55017 102532 103501 746981 529927 166834 101734 1029795 661145 203537 106504 980287 470469 191840 90559 1033308 344422 117732 74861 1074286 314220 150467 69310 1459852 534211 190998 188387 1887676 655965 122567 717176 1864464 562022 96157 700031 1742415 283847 -550202 588599 1121318 265739 18387 27478 107933 69597 21795 55483 101014 45161 25571 90866 113598 54861 10386079 3317184 -1947236 134301 32 33 34 35 36 37 37 38 39 18010 85186 40 41 42 43 44 45 46 47 48 49 50 66724 100018 17862 40348 77766 26339 30974 81329 17216 116057 155139 57749 182302 51 52 53 54 55 56 57 58 59 150462 42145 126261 232048 87 10066 26720 24440 22146 60 61 188601 194949 267480 300534 401140 011 322491 276501 213438 205393 137101 331071 399269 357350 418809 595227 59522 549740 567675 449330 520353 169792 133291 712983 549545 88030 70421 161983 190449 216016 246558 267402 392561 470983 1853733 1801610 1510658 1442096 56758 90096 93464 62 63 64 78728 65 66 67 68 69 70 214156 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 99106 233836 225390 471681 256032 182282 111181 153221 20429 350240 608960 1003202 1005950 1308288 3184500 2543590 1227940 859558 656071 520997 115000 158000 151000 158000 291000 660001 632000 440000 400000 376184 395109 1874058 1523466 2060388 5445681 5600735 6790495 9130620 8077132 8109872 10730244 17422369 8109872 72900 99000 66400 59936 72000 54400 56000 35154 141111 138019 694667 659995 237741 234640 150 110061 110717 81692 67522 122304 153870 1805191 1638215 1280748 1089180 6080 25256 21621 26917 18960 29645 155371 137386 109567 76048 63181 27141 52021 32024 75403 110050 323893 799192 960264 007 858917 875082 1423715 1610294 35822 31234 36136 48334 48492 40058 32771 36481 27594 48862 40981 63345 80270 544205 617850 111480 2592 63 100000 84000 57252 45375 43576 69004 1317581 1289952 149474 24428 5345 21289 15407 9919 3368 11731 104586 79960 55349 30750 7785 16188 44812 65864 58421 254788 690914 836703 593809 713537 1008611 1232752 20239 16933 19092 32550 25104 17392 9284 5701 1851 84865 487610 348263 . 1131274 1064752 735 3968 6214 16999 15592 17914 50784 57426 54218 45298 55396 10954 7207 9539 33 51629 69105 108278 123561 265108 161545 51645 415104 377542 15583 378115 399217 522424 586127 1251807 966590 460307 295900 377553 462558 547086 690644 738419 988114 1314808 3287517 3107798 2681384 2671583 274887 271319 21 351095 337033 411758 497598 667296 666462 661098 607649 657297 648306 748805 884896 1067617 2033114 2812788 3217209 3581982 4075053 5752134 6308368 98809 101875 125746 171206 165528 161853 170474 176287 137141 -27038 7635 -173961 8372 -161594 74705 52718 85017 111665 132237 164762 202786 270643 186212 26200 289778 21905 37316 29468 33638 52301 61127 82241 72168 54207 57558 41987 66563 96920 30929 118561 165012 173791 201336 235073 386194 324518 375495 549927 97154 132758 229723 226786 192003 163525 151324 166070 144692 153711 223718 395754 667781 892408 672309 833756 853038 1603044 13677 27433 31702 51402 63198 68063 64670 59461 31471 192549 265523 317140 392805 363947 398432 369582 427877 333149 476508 577190 659892 1198138 1431320 1469456 1891784 1790633 2759110 2367218 78128 71551 93670 107471 89996 81456 93770 104792 82059 114674 126798 219308 209216 419762 275501 261114 427577 57532 36804 89266 108650 92859 271650 277396 764130 535703 1334284 1299129 98642 57770 130129 107592 157120 209616 244738 255156 259611 205317 274127 233476 236140 309536 399240 554210 750042 798444 2000 988291 934523 1609557 1527167 30440 27233 34286 38005 41009 40904 50971 54017 32515 88 15653 14302 89 90 91 92 93 94 95 96 97 98 99 100 17044 15785 23388 22667 23488 30781 25743 15410 23055 7152 5842 9131 14534 13854 -9351 419 219 484890 101 102 103 104 105 106 107 108 109 110 111 112 113 1872 -7440 -409500 399693 164491 - 139075 -95972 -180790 114 115 116 117 118 119 120 121 122 123 124 125 126 127 36729 51101 2430000 3156000 3228000 2754000 2520000 1908000 1407000 1491000 609000 4890000 1398000 689779 656188 757896 691195 236275 591976 236275 591976 877077 506190 429673 270753 82403 506190 27450 25285 484890 479668 450000 834955 1184893 1739633 1758275 1481054 1416913 1205008 1150632 219 79589 219 219 219 219 1033862 1103252 668483 723017 712255 684151 650508 49100 255750 305531 48354 661303 445082 244896 274392 250693 573923 48354 661303 445082 244896 274392 250693 573923 687375 998804 895919 734279 633252 64952 148856 0 450000 830220 1183920 1236120 839160 450000 1329589 1125905 595537 0 79369 0 2 0 0 0 0 888741 700610 539006 541872 505561 347027 50377 5750 2900 302631 48354 295280 227063 146088 174853 165943 459783 48354 295280 227063 146088 174853 165943 459783 544422 625295 693089 113526 113526 51929 70002 27031 25066 0 479668 0 4735 973 503513 919115 1031054 87324 79103 555095 219 219 219 219 219 219 145121 402642 129478 181145 206665 337124 600132 43350 252850 2900 0 366023 218019 98808 99539 84750 114140 0 366023 218019 98808 99539 84750 114140 142953 373509 202830 620751 633252 13023 78855 134537 129443 3089703 3329633 3546165 4204075 4170232 4490697 2811090 2950216 3079231 3652053 4170331 233514 370249 545194 551037 1269167 1319586 1467714 1534413 1736505 1474170 1332024 1263672 743766 1647350 2660931 4783874 3087900 1495590 1141091 823845 810185 757835 1182251 3087900 1495590 1141091 823845 810185 757835 1182251 1384388 1790734 1700799 1400821 1349378 530053 715531 29294 28760 1172327 1107345 1153515 1474848 1724759 1667822 1104821 1029335 851282 736834 1280770 660 3831 61078 55451 211452 202616 1036703 1203594 1378168 1288423 1191850 1114209 627764 634967 COC 685244 928851 1595204 659068 460698 400934 428075 474305 961556 1595204 659068 460698 400934 428075 474305 961556 1122642 1596247 1529235 1246621 1208043 131732 360052 86378 87669 1910868 2216935 2388568 2709706 2418807 2733836 1585840 1919038 2174681 2875154 2728034 220596 127307 109545 86480 58629 83587 176264 135284 170393 181514 135943 148194 116002 960377 1904260 33950 37520 571734 1049127 838218 1391069 1179506 1706489 1647246 1823126 739203 695412 1508614 1328 49280 36880 39300 150658 125070 246511 491898 160478 258194 265788 410976 668065 962824 1723216 3240313 726027 505171 347524 166173 159969 127687 155763 726027 505171 347524 166173 159969 127687 155763 180749 416652 276088 812580 910659 156703 283484 429673 3785656 -1164718 403607 375371 1036948 29865 -4358 -6320 -17748 -31936 12696 65166 30350 75063 106502 -326629 -109624 -11421 -406248 237354 349469 380659 -126193 152225 82145 -50329 -51089 10040 84009 -126193 152225 82145 -50329 -51089 10040 84009 121505 -58369 26769 -127343 17588 65178 34140 128 129 130 131 132 133 134 135 136 137 138 139 270753 872000 372000 431520 477125 388676 534744 1156283 872000 140 141 142 143 1275687 797239 487461 216054 156529 137013 139920 1275687 797239 487461 216054 156529 137013 139920 196126 108405 111841 108676 95214 391046 338100 372000 431520 477125 388676 534744 1156283 819813 1198845 819813 253003 167371 247650 321750 144 145 146 147 148 149 150 302251 244531 336766 691763 556628 404393 304900 515 108518 103136 19401 104850 178757 121250 69375 2185 412 20304 24297 28646 12414 41811 28498 -156528 -86438 355581 373754 370944 419988 662857 610997 379104 396922 328183 577939 895658 954617 -11849 353141 425475 425475 445245 447430 436878 340283 287655 265818 828178 806203 830244 809012 802484 945705 my 981591 977502 956007 960186 103136 103136 103136 1421523 103136 103136 103136 198276 158126 92014 0 1679618 1637599 1270801 1079577 1509921 1596977 1871490 4520960 4675324 690744 0 3805776 11326260 15854690 5002549 13288219 19325917 5717015 16238029 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 129982 572400 696600 739800 955800 777600 810000 699300 1350000 1120500 3655800 1692900 14612749 26305560 15944698 11226978 10255932 4493969 230898 -- 340849 421477 055 282153 936710 2365046 1217648 491741 515157 245870 337484 477206 426404 328513 542539 - 676081 380781 364327 352070 131119 5550930 36978 49840 44211 204126 219398 194314 1919 199290 349971 342308 238116 198963 124115 825008 807950 616307 821553 900000 900000 988276 543822 307960 0 390000 5940972 12360623 16953266 18329167 18647017 16415155 677100 551945 31452 1005 28963 468339 469550 431089 300372 245057 217726 1262963 1301390 1086791 1068898 975544 1077576 1059725 771178 771098 716326 1711456 487401 160017 588268 15135967 14692954 581083 412226 15718 10186 276812 223460 168475 103005 49407 76822 975508 807588 612020 320845 300092 368054 289859 174810 123661 150944 1107505 334610 95608 116262 174913 94440 171214 221058 168741 15:55 196778 123702 825008 807950 616307 821553 900000 900000 790000 385696 215946 0 390000 2135196 1034362 1098576 2091138 3511050 1722201 96015 139720 15734 18777 191527 246090 262614 197367 195650 140904 287455 493802 474771 748053 675452 709522 769866 596368 647437 565382 603951 152792 121985 86695 708722 799229 809626 873738 1112457 1106025 830241 834635 648777 1753925 2017842 2093723 2532125 2775349 2791898 2442642 2270784 2646267 2723214 3135220 15152889 26499994 34209807 36280636 37227690 29889079 1806156 1581778 863882 687313 1472561 1652939 1792507 1552057 1364894 1025612 2878372 3015004 2387665 2195030 2633223 2680589 2775775 2512854 2396852 2003653 4370254 665491 829356 815719 -290315 223191 388889 226628 189740 -8841 -24925 342288 341914 536072 308391 919775 1416777 2001632 -170432 695423 -1771481 64695 -74826 -26881 -108747 135486 156292 145303 42696 -87543 - 158029 187341 133421 -20733 -20422 19613339 19538887 15392779 695571 659227 66798 439183 528267 561757 582225 536985 525991 384624 632875 577425 415585 336590 607898 646220 659640 608818 590886 441585 1273090 420772 11649 680600 6828376 7307535 4726814 384001 287897 789174 220534 776555 919134 1021896 820898 667042 463368 1289100 1475650 1293514 1316836 1647852 Top 1684657 1747872 1532444 1459392 1244150 2784346 170300 769316 92714 265530 325764 404165 260461 410504 426821 343202 387709 295983 1302677 1389178 1210804 1534187 1711766 -- 1827978 1403854 1025751 1284097 1111499 1351896 4555519 4389685 4454961 6544537 7329433 4627986 202430 231136 172604 103016 543655 659030 719608 540767 489778 397530 861461 1034426 842969 1325950 1254656 1300377 1380430 1134222 1178161 1164184 1084452 229892 752737 233055 105950 114830 143811 70104 -97441 -229667 499747 -43487 -66635 -4273 38032 501572 201 202 203 204 205 542539 676081 380781 364327 352070 131119 5550930 36978 49840 44211 975544 1077576 1059725 771178 771098 716326 1711456 487401 160017 588268 300092 368054 289859 174810 123661 150944 1107505 334610 38032 501572 675452 709522 769866 596368 647437 565382 603951 152792 121985 86695 2633223 2680589 2775775 2512854 2396852 2003653 4370254 665491 829356 815719 105950 114830 143811 70104 -97441 -229667 499747 -43487 -66635 -4273 607898 646220 659640 608818 590886 441585 1273090 420772 11649 680600 1647852 1684657 1747872 1532444 1459392 1244150 2784346 170300 769316 92714 1254656 1300377 1380430 1134222 1178161 1164184 1084452 229892 752737 233055 206 207 208 209 210