Question: need help pls and thank you he database summarizes financial information for 32 companies and their perceived risk of default. Convert these data into an



he database summarizes financial information for 32 companies and their perceived risk of default. Convert these data into an with a risk of default, and also for those without a risk of default. Does there appear to be a difference between companies with a Click the icon to view the financial information for the 32 companies. GOOD Convert these data into an Excel table. Use table-based calculations to find the average debt for companies with a risk of default. The average debt for companies with a risk of default is $ (Round to the nearest whole number as needed.) 13 Company 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Category Credit Score Service 604 Manufacturing 714 Manufacturing 732 Manufacturing 792 Service 623 Manufacturing 702 Service 764 Manufacturing 690 Service 802 Service 610 Manufacturing 590 Manufacturing 824 Service 762 Manufacturing 601 Manufacturing 655 Equity Default Assessment Yes No No Debt 11,335,555 3,874,882 3,408,749 2,189,077 151,549 1,552,789 8,004,212 11,760,488 3,131,242 720,723 13,605,261 4,316,958 4,887,268 6,267,887 7,450,422 5,550,924 7,503,106 11,112,926 14,819,627 3,664,443 8,953,614 19,983,461 586,996 31,295,990 4,954,838 4,565,729 1,716,165 328,403 39,209,251 14,632,737 No Yes Yes No No No Yes No No No Yes Yes T4 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Manufacturing OUT 1,710.109 320,403 Manufacturing 655 39,209,251 14,632,737 Manufacturing 792 4,510,959 4,611,286 Manufacturing 721 3,606,010 14,346,278 Manufacturing 750 12,890,457 11,435,376 Manufacturing 762 5,402,556 18,850,777 Service 598 2,784,417 561,036 Manufacturing 742 7,805,669 4,469,580 Manufacturing 821 3,385,200 14,270,045 Service 657 3,482,925 5,365,323 Manufacturing 3,981,211 3,175,444 798 Manufacturing 695 9,891,656 5,655,781 Service 10,246,277 9,025,935 819 671 23,704,753 6,610,450 Manufacturing Manufacturing 771 9,894,921 6,595,598 Service 832 11,893,904 13,597,877 Service 759 800,208 1,996.174 Tes Yes No No No No Yes No No Yes No No No Yes No No No 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Manufacturing 721 Manufacturing 750 Manufacturing 762 Service 598 Manufacturing 742 Manufacturing 821 Service 657 Manufacturing 798 Manufacturing 695 Service 819 Manufacturing 671 Manufacturing 771 Service 832 Service 759 Manufacturing 613 Manufacturing 705 3,606,010 14,346,278 12,890,457 11,435,376 5,402,556 18,850,777 2,784,417 561,036 7,805,669 4,469,580 3,385,200 14,270,045 3,482,925 5,365,323 3,981,211 3,175,444 9,891,656 5,655,781 10,246,277 9,025,935 23,704,753 6,610,450 9,894,921 6,595,598 11,893,904 13,597,877 800,208 1,996,174 5,915,001 833,131 6,989,104 5,750,512 No No No Yes No No Yes No No No Yes No No No Yes No
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
