80.2K

Verified Solution

Link Copied!

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 S Round to the nearest whole number as needed 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 2 Manufacturing 3 Manufacturing 4 Manufacturing 5 Service 6 Manufacturing 7 Service 8 Manufacturing 9 Service 10 Service 11 Manufacturing 12 Manufacturing 13 Service 14 Manufacturing 15 Manufacturing 16 Manufacturing 17 Manufacturing 18 Manufacturing 19 Manufacturing 20 Service 21 Manufacturing 22 Manufacturing 23 Service 24 Manufacturing 25 Manufacturing 26 Service 27 Manufacturing 714 4019529 2216629 No 732 171407 1782738 No 792 8084984 11918008 No 623 3170474 755648 Yes 702 13199975 4095573 Yes 764 4116956 6847610 No 690 7121992 5938446 No 802 7969203 11550605 No 610 14389772 3686534 Yes 590 8003572 19978215 No 824 583316 31212038 No 762 2252811 4519299 No 601 1776398 305758 Yes 655 39129388 14997345 Yes 792 4634857 4612049 No 721 3927187 14233030 No 750 12692273 11439891 No 762 5159636 18835016 No 598 2515454 538035 Yes 742 7075389 4262423 No 821 3668641 14139966 No 657 3815570 5221776 Yes 798 3102714 3263735 No 695 9877320 5642938 No 819 10076016 9212560 No 671 23680348 6665172 Yo

Answer & Explanation Solved by verified expert

See Answer