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.

The average debt for companies with a risk of default is $$?.$

$($Round to the nearest whole number as needed.$)$

Use table$-$based calculations to find the average debt for companies without a risk of default.

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

$($Round to the nearest whole number as needed.$)$

Use table$-$based calculations to find the average equity for companies with a risk of default.

The average equity for companies with a risk of default is $

$($Round to the nearest whole number as needed.$)$

Use table$-$based calculations to find the average equity for companies without a risk of default.

The average equity for companies without a risk of default is $

$($Round to the nearest whole number as needed.$)$

$$

Transcribed Image Text:

A C D F 0.... 1 Company Category Credit Score 2 3 1 Service 2 Manufacturing 604 Debt 10006724 Equity Default Assessment 3922421 Yes 714 4476720 2263580 No 4 3 Manufacturing 732 4 Manufacturing 792 6 5 Service 176513 8487077 623 3084200 1913708 No 11297743 No 770143 Yes reen 7 6 Manufacturing 702 13854332 4298691 Yes O.... 8 7 Service 764 9 8 Manufacturing 690 4755860 7857190 6434703 No 5536097 No 10 9 Service 802 7834620 11610000 No 11 10 Service 610 14121337 3550515 Yes 12 11 Manufacturing 590 8992556 19531786 No 13 12 Manufacturing 824 587664 31380417 No reer 141 13 Service 762 5275682 4544820 No 0... 15 14 Manufacturing 16 15 Manufacturing 17 16 Manufacturing 18 17 Manufacturing 721 19 18 Manufacturing 750 601 1611249 655 30288140 792 4867255 3625424 12245197 321382 Yes 14810209 Yes 4525076 No 14090771 No 11428480 No 20 19 Manufacturing 762 5158503 18780733 No 21 20 Service 598 2754965 505557 Yes reen 22 21 Manufacturing 742 7816887 4194544 No 0... 23 22 Manufacturing 821 3144785 14135456 No 24 23 Service 657 25 24 Manufacturing 798 3808438 3156907 5424093 Yes 26 25 Manufacturing 27 26 Service 695 9683465 819 10847440 28 27 Manufacturing 671 23932330 reen 29 28 Manufacturing 771 0...30 29 Service 832 31 30 Service 759 32 31 Manufacturing 613 33 32 Manufacturing 705 9033904 11675637 873454 5930463 6573786 3476801 No 5690242 No 9233510 No 6560073 Yes 6716614 No 13994837 No 1860978 No 825296 Yes 5550041 No 34 35 36 reer 37 12 G H . K L M A C D F 0.... 1 Company Category Credit Score 2 3 1 Service 2 Manufacturing 604 Debt 10006724 Equity Default Assessment 3922421 Yes 714 4476720 2263580 No 4 3 Manufacturing 732 4 Manufacturing 792 6 5 Service 176513 8487077 623 3084200 1913708 No 11297743 No 770143 Yes reen 7 6 Manufacturing 702 13854332 4298691 Yes O.... 8 7 Service 764 9 8 Manufacturing 690 4755860 7857190 6434703 No 5536097 No 10 9 Service 802 7834620 11610000 No 11 10 Service 610 14121337 3550515 Yes 12 11 Manufacturing 590 8992556 19531786 No 13 12 Manufacturing 824 587664 31380417 No reer 141 13 Service 762 5275682 4544820 No 0... 15 14 Manufacturing 16 15 Manufacturing 17 16 Manufacturing 18 17 Manufacturing 721 19 18 Manufacturing 750 601 1611249 655 30288140 792 4867255 3625424 12245197 321382 Yes 14810209 Yes 4525076 No 14090771 No 11428480 No 20 19 Manufacturing 762 5158503 18780733 No 21 20 Service 598 2754965 505557 Yes reen 22 21 Manufacturing 742 7816887 4194544 No 0... 23 22 Manufacturing 821 3144785 14135456 No 24 23 Service 657 25 24 Manufacturing 798 3808438 3156907 5424093 Yes 26 25 Manufacturing 27 26 Service 695 9683465 819 10847440 28 27 Manufacturing 671 23932330 reen 29 28 Manufacturing 771 0...30 29 Service 832 31 30 Service 759 32 31 Manufacturing 613 33 32 Manufacturing 705 9033904 11675637 873454 5930463 6573786 3476801 No 5690242 No 9233510 No 6560073 Yes 6716614 No 13994837 No 1860978 No 825296 Yes 5550041 No 34 35 36 reer 37 12 G H . K L M