The database below 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?

The average debt for companies with a risk of default is ____

The average debt for companies without a risk of default is ____

The average debt for companies with a risk of default is ____

The average debt for companies without a risk of default is ______

i Financial Information Company Yes Category Credit Score Service 604 Manufacturing 714 Manufacturing 732 Manufacturing 792 Service 623 Manufacturing 702 Service Manufacturing Service Service 610 Manufacturing 590 Manufacturing 824 Service 762 Manufacturing Manufacturing 655 Manufacturing Manufacturing 721 Manufacturing 750 690 802 Debt Equity Default Assessment 10,044,623 3,513,613 3,049,092 2,144,226 190,960 1,696,936 8,772,087 11,550,839 3,170,614 733,948 13,059,607 4,281,229 4,365,203 6,907,472 7,943,381 5,720,303 7,964,026 11,926,743 14,593,526 3,853,367 8,710,715 19,996,329 573,762 31,482,575 8,121,784 4,529,035 1,579,240 308,448 30,992,940 14,579,279 4,665,711 4,608,937 3,946,626 14,030,738 12,001,929 11,262,613 z z zgo 3 z 3 g Z z zgo z z 601 Print Done 601 792 Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Service Manufacturing Manufacturing Service Manufacturing Manufacturing Service Manufacturing Manufacturing Service Service Manufacturing Manufacturing 1,579,240 308,448 30,992,940 14,579,279 4,665,711 4,608,937 3,946,626 14,030,738 12,001,929 11,262,613 5,461,619 18,770,014 2,632,592 564,504 7,558,691 4,002,784 3,786,980 14,487,159 3,706,851 5,013,602 3,463,129 3,129,500 9,814,282 5,570,053 10,773,539 9,207,861 23,831,167 6,571,762 9,278,299 6,897,587 11,914,533 13,698,637 886,905 1,543,452 5,918,575 805,715 6,675,657 5,547,487 za 3 z zgz z zg z zz zz zo goede 695 771 832 759 613 705 Print Dom