The database summarizes financial information for 32 companies and their perceived risk of default. Convert these...

Transcribed Image Text:

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.) Financial Information Company 1 2 3 4 5 6 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 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 Manufacturing 792 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 613 705 Manufacturing Manufacturing C Print Debt 10,691,720 3,028,380 2,247,074 1,955,466 151,717 8,753,020 11,204,718 3,133,684 Equity Default Assessment 3,787,060 727,977 13,856,135 4,090,724 4,464,931 6,677,161 7,644,538 5,900,329 7,335,531 11,224,387 14,599,817 3,795,653 8,581,230 19,500,590 574,582 31,459,485 3,424,104 4,689,668 1,675,306 309,820 35,958,907 14,938,051 4,529,438 4,638,880 3,627,795 14,408,048 12,976,174 11,442,651 5,341,597 18,809,702 2,726,401 571,663 7,532,615 4,113,509 3,966,349 14,337,314 3,720,651 5,427,425 3,798,946 3,191,625 9,616,278 5,564,915 10,555,554 9,128,869 23,590,152 6,760,232 9,311,398 6,945,031 11,602,175 13,837,916 897,684 1,576,766 5,972,515 822,009 6,894,354 5,679,348 Done Yes No No No Yes Yes No No No Yes No No No Yes Yes No No No No Yes No No Yes No No No Yes No No No Yes No X 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.) Financial Information Company 1 2 3 4 5 6 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 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 Manufacturing 792 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 613 705 Manufacturing Manufacturing C Print Debt 10,691,720 3,028,380 2,247,074 1,955,466 151,717 8,753,020 11,204,718 3,133,684 Equity Default Assessment 3,787,060 727,977 13,856,135 4,090,724 4,464,931 6,677,161 7,644,538 5,900,329 7,335,531 11,224,387 14,599,817 3,795,653 8,581,230 19,500,590 574,582 31,459,485 3,424,104 4,689,668 1,675,306 309,820 35,958,907 14,938,051 4,529,438 4,638,880 3,627,795 14,408,048 12,976,174 11,442,651 5,341,597 18,809,702 2,726,401 571,663 7,532,615 4,113,509 3,966,349 14,337,314 3,720,651 5,427,425 3,798,946 3,191,625 9,616,278 5,564,915 10,555,554 9,128,869 23,590,152 6,760,232 9,311,398 6,945,031 11,602,175 13,837,916 897,684 1,576,766 5,972,515 822,009 6,894,354 5,679,348 Done Yes No No No Yes Yes No No No Yes No No No Yes Yes No No No No Yes No No Yes No No No Yes No No No Yes No X

Answer rating: 100% (QA)

Important formula The average debt for companies with a risk of default or with Yes Default Data is Sum of All the Debt values with Default Assessment Yes divided by Number of Company with Default Ass... View the full answer