please help andwer this question, it has five parts.

business analytics

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 averace equitv for companies without a risk of default is \begin{tabular}{|c|c|c|c|c|c|} \hline Company & Category & Credil Score & Debt & Equity & Default Assessment \\ \hline 1 & Service & 604 & 10,048,463 & 3,763,578 & Yes \\ \hline 2 & Manufacturing & 714 & 3,123,884 & 2,477,871 & No \\ \hline 3 & Manufacturing & 732 & 180,860 & 1,767,153 & No \\ \hline 4 & Manufacturing & 792 & 8,197,564 & 11,121,881 & No \\ \hline 5 & Service & 623 & 3,157,880 & 774,823 & Yes \\ \hline 6 & Manufacturing & 702 & 13,442,709 & 4,044,363 & Yes \\ \hline 7 & Service & 764 & 4,676,170 & 6,959,516 & No \\ \hline 8 & Manufacturing & 690 & 7,378,672 & 5,524,230 & No \\ \hline 9 & Service & 802 & 7,389,776 & 11,190,610 & No \\ \hline 10 & Service & 610 & 14,153,723 & 3,629,583 & Yes \\ \hline 11 & Manufacturing & 590 & 8,862,851 & 19,848,093 & No \\ \hline 12 & Manufacturing & 824 & 551,687 & 31,329,657 & No \\ \hline 13 & Service & 762 & 7,769,096 & 4,662,755 & No \\ \hline 14 & Manufacturing & 601 & 1,650,792 & 343,064 & Yes \\ \hline 15 & Manufacturing & 655 & 36,310,624 & 14,538,760 & Yes \\ \hline 16 & Manufacturing & 792 & 4,672,272 & 4,632,879 & No \\ \hline 17 & Manufacturing & 721 & 3,731,888 & 14,208,423 & No \\ \hline 18 & Manufacturing & 750 & 12,808,925 & 11,436,232 & No \\ \hline 19 & Manufacturing & 762 & 5.326 .761 & 18,847,616 & No \\ \hline 20 & Service & 598 & 2,718,504 & 500,962 & Yes \\ \hline 21 & Manufacturing & 742 & 7,554,009 & 4,347,717 & No \\ \hline 22 & Manufacturing & 821 & 3,157,478 & 14,085,274 & No \\ \hline 23 & Service & 657 & 3,902,540 & 5,435,338 & Yes \\ \hline 24 & Manufacturing & 798 & 3.130,680 & 3,480,184 & No \\ \hline 25 & Manufacturing & 695 & 9.867,302 & 5,534,046 & No \\ \hline 26 & Service & 819 & 10.701,101 & 9,291,552 & No \\ \hline 27 & Manufacturing & 671 & 23.886 .705 & 6.731 .480 & Yes \\ \hline 28 & Manutacturing & 771 & 9,220.475 & 6.912,582 & No: \\ \hline 29 & Service & 832 & 11,570,517 & 13,834,650 & No \\ \hline 30 & Service & 759 & 822,304 & 1.727 .847 & No \\ \hline 31 & Manufacturing & 613 & 5.923,315 & 811,882 & Yes \\ \hline 32 & Manufacturing & 705 & 6,667,283 & 5.583 .365 & No \\ \hline \end{tabular} Does there appear to be a difference between companies with and without a risk of default? A. Yes, companies with risk of default tend to have a higher debt and higher equity. B. No, there does not appear to be a difference between companies with and without risk of default. C. Yes, companies with risk of default tend to have a lower debt and higher equily. D. Yes, companies with risk of default tend to have a higher debt and lower equity. E. Yes, companies with risk of default tend to have a lower debt and lower equity. The database summarizes financial information for 32 companies and their percelved risk of defautt, Convert these data into an Excel table. Use tablo-based calculations to find the average debt and average equily for companios with a tisk of default, and also for those without a risk of defaut Does thore appear to bo a ditference betwoen companies with and without a risk of defaulin? Click the icon to view the financial information for the 32 companios Convert these data into an Excel table Use table-based calculations to find the average debt tor companies with a risk of default. The average debt for companies with a risk of defautt is $ (Round to the nearest whole number as needed) 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 averace equitv for companies without a risk of default is \begin{tabular}{|c|c|c|c|c|c|} \hline Company & Category & Credil Score & Debt & Equity & Default Assessment \\ \hline 1 & Service & 604 & 10,048,463 & 3,763,578 & Yes \\ \hline 2 & Manufacturing & 714 & 3,123,884 & 2,477,871 & No \\ \hline 3 & Manufacturing & 732 & 180,860 & 1,767,153 & No \\ \hline 4 & Manufacturing & 792 & 8,197,564 & 11,121,881 & No \\ \hline 5 & Service & 623 & 3,157,880 & 774,823 & Yes \\ \hline 6 & Manufacturing & 702 & 13,442,709 & 4,044,363 & Yes \\ \hline 7 & Service & 764 & 4,676,170 & 6,959,516 & No \\ \hline 8 & Manufacturing & 690 & 7,378,672 & 5,524,230 & No \\ \hline 9 & Service & 802 & 7,389,776 & 11,190,610 & No \\ \hline 10 & Service & 610 & 14,153,723 & 3,629,583 & Yes \\ \hline 11 & Manufacturing & 590 & 8,862,851 & 19,848,093 & No \\ \hline 12 & Manufacturing & 824 & 551,687 & 31,329,657 & No \\ \hline 13 & Service & 762 & 7,769,096 & 4,662,755 & No \\ \hline 14 & Manufacturing & 601 & 1,650,792 & 343,064 & Yes \\ \hline 15 & Manufacturing & 655 & 36,310,624 & 14,538,760 & Yes \\ \hline 16 & Manufacturing & 792 & 4,672,272 & 4,632,879 & No \\ \hline 17 & Manufacturing & 721 & 3,731,888 & 14,208,423 & No \\ \hline 18 & Manufacturing & 750 & 12,808,925 & 11,436,232 & No \\ \hline 19 & Manufacturing & 762 & 5.326 .761 & 18,847,616 & No \\ \hline 20 & Service & 598 & 2,718,504 & 500,962 & Yes \\ \hline 21 & Manufacturing & 742 & 7,554,009 & 4,347,717 & No \\ \hline 22 & Manufacturing & 821 & 3,157,478 & 14,085,274 & No \\ \hline 23 & Service & 657 & 3,902,540 & 5,435,338 & Yes \\ \hline 24 & Manufacturing & 798 & 3.130,680 & 3,480,184 & No \\ \hline 25 & Manufacturing & 695 & 9.867,302 & 5,534,046 & No \\ \hline 26 & Service & 819 & 10.701,101 & 9,291,552 & No \\ \hline 27 & Manufacturing & 671 & 23.886 .705 & 6.731 .480 & Yes \\ \hline 28 & Manutacturing & 771 & 9,220.475 & 6.912,582 & No: \\ \hline 29 & Service & 832 & 11,570,517 & 13,834,650 & No \\ \hline 30 & Service & 759 & 822,304 & 1.727 .847 & No \\ \hline 31 & Manufacturing & 613 & 5.923,315 & 811,882 & Yes \\ \hline 32 & Manufacturing & 705 & 6,667,283 & 5.583 .365 & No \\ \hline \end{tabular} Does there appear to be a difference between companies with and without a risk of default? A. Yes, companies with risk of default tend to have a higher debt and higher equity. B. No, there does not appear to be a difference between companies with and without risk of default. C. Yes, companies with risk of default tend to have a lower debt and higher equily. D. Yes, companies with risk of default tend to have a higher debt and lower equity. E. Yes, companies with risk of default tend to have a lower debt and lower equity. The database summarizes financial information for 32 companies and their percelved risk of defautt, Convert these data into an Excel table. Use tablo-based calculations to find the average debt and average equily for companios with a tisk of default, and also for those without a risk of defaut Does thore appear to bo a ditference betwoen companies with and without a risk of defaulin? Click the icon to view the financial information for the 32 companios Convert these data into an Excel table Use table-based calculations to find the average debt tor companies with a risk of default. The average debt for companies with a risk of defautt is $ (Round to the nearest whole number as needed)