Question: Please help me solve this. The database summarizes financial information for 32 companies and their perceived risk of default. Convert these data into an Excel





Please help me solve this.
The database summarizes financial information for 32 companies and their perceived risk of default. Convert these data into an Excel table. Use table-based calculations to find the average debt and average equity for companies with a risk of default, and also for those without a risk of default. Does there appear to be a difference between companies with and without a risk of default? Click the icon to view the financial information for the 32 companies. 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.) Company Category Credit Score 3 1 Service 604 Debt Equity Default Assessment 11,985,050 3,582,616 Yes 3,013,119 2,095,790 No 190,816 1,881,411 No 2 714 3 Manufacturing Manufacturing Manufacturing 732 4 792 8,498,525 11,005,040 No 5 Service 623 3,044,694 786,304 Yes 6 Manufacturing 702 13,980,331 4,469,325 Yes 7 Service 764 4,521,290 6,409,171 No 8 Manufacturing 690 7,683,969 5,774,240 No 9 Service 802 7,018,809 11,870,807 No 10 Service 610 14,296,214 3,733,164 Yes 11 Manufacturing 590 8,709,545 19,690,815 No 12 Manufacturing 824 563.247 31 088 243 No 9 Service 802 7,018,809 11,870,807 No 10 Service 610 14,296,214 3,733,164 Yes 11 590 8,709,545 19,690,815 No Manufacturing Manufacturing 12 824 563,247 31,088,243 No 13 Service 762 5,368,293 4,631,639 No 14 601 1,698,234 336,975 Yes Manufacturing Manufacturing 15 655 32,528,135 14,626,878 Yes 16 792 4,697,334 4,657,869 No 17 721 3,805,526 14,229,395 No Manufacturing Manufacturing Manufacturing Manufacturing 18 750 12,979,623 11,474,309 No 19 762 5,402,002 18,749,334 No 20 Service 598 2,559,870 538,352 Yes 21 Manufacturing 742 7 305 384 4 331 894 No 15 655 32,528,135 14,626,878 Yes 16 792 4,697,334 4,657,869 No 17 Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing 721 3,805,526 14,229,395 No 18 750 12,979,623 11,474,309 No 19 762 5,402,002 18,749,334 No 20 Service 598 2,559,870 538,352 Yes 21 742 7,305,384 4,331,894 No Manufacturing Manufacturing 22 821 3,263,995 14,197,404 No 23 Service 657 3,727,677 5,491,073 Yes 24 798 3,275,759 3,343,571 No Manufacturing Manufacturing 25 695 9,903,165 5,664,869 No Service 819 10,640,401 9,059,447 No 27 Manufacturing 671 23.786.045 6.651.618 Yes 21 742 No Manufacturing Manufacturing 22 821 7,305,384 4,331,894 3,263,995 14,197,404 3,727,677 5,491,073 No 23 Service 657 Yes 24 798 3,275,759 3,343,571 No Manufacturing Manufacturing 25 695 9,903,165 5,664,869 No 26 Service 819 10,640,401 9,059,447 No 27 671 23,786,045 6,651,618 Yes Manufacturing Manufacturing 28 771 9,065,290 6,671,326 No 29 Service 832 11,636,775 13,669,965 No 30 Service 759 859,494 1,974,601 No 31 613 5,977,541 830,934 Yes Manufacturing Manufacturing 32 705 6,551,227 5,872,629 NoStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
