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.)

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.)

Does there appear to be a difference between companies with and without a risk of default? a.no, there does not appear to be difference between companies with and without risk of default.

b. yes, companies with risk of default tend to have a lower debt and higher equity

c. yes, companies with risk of default tend to have a higher debt and higher equity

d. yes, companies with risk of default tend to have a higher debt and lower equity.

f. yes, companies with risks of default tend to have a lower debt and lower equity.

AutoSave oft data-10.1.2020-1.18 PM - Protected View - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable A1 Company G H 1 B 1 Company Category 1 Service 3 2 Manufacturing 3 Manufacturing 5 4 Manufacturing 6 S Service 7 6 Manufacturing 8 7 Service 7 9 8 Manufacturing 10 9 Service 11 10 Service 12 11 Manufacturing 13 12 Manufacturing 14 13 Service 15 14 Manufacturing 16 15 Manufacturing 17 16 Manufacturing 18 17 Manufacturing 19 18 Manufacturing 20 19 Manufacturing 21 20 Service 22 21 Manufacturing 23 22 Manufacturing 24 23 Service 25 24 Manufacturing 26 25 Manufacturing 27 26 Service 28 27 Manufacturing 29 28 Manufacturing 30 29 Service 31 30 Service 32 31 Manufacturing 33 32 Manufacturing 34 C D . Credit Score Debt Equity Default Assessment 604 11321843 3835264 Yes 714 4718379 2324594 No 732 155971 1709558 No 792 8552170 11536456 No 623 3080313 758882 Yes 702 13984456 4127046 Yes 764 4215465 6111412 No 690 7311486 5919418 No 802 7405082 11602836 No 610 14181855 3803577 Yes 590 8588373 19813049 No 824 555359 31216184 No 762 2094763 4678445 No 601 1652941 314280 Yes 655 35698382 14985439 Yes 792 4896979 4670256 No 721 3833970 14331391 No 750 12428431 11249034 NO 762 5224627 18877678 No 598 2660625 543286 Yes 742 7544437 4146224 No 821 3371794 14204060 No 657 3860478 5181137 Yes 798 3164750 3407974 No 695 9526878 5657449 NG 819 10863234 9032839 No 671 23823500 6844458 Yes 771 9819878 6810356 No 832 11668 167 13582289 No 759 886084 1939565 No 613 5960205 822532 Yes 705 6595688 5901517 No Ready i H Type here to search ESC # $ % 2 6 3 4 5