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. (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 $7 (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 $C (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 $0. (Round to the nearest whole number as needed.) Does there appear to be a difference between companies with and without a risk of default? O A. Yes, companies with risk of default tend to have a higher debt and higher equity. OB. Yes, companies with risk of default tend to have a higher debt and lower equily. O C. Yes, companies with risk of default tend to have a lower debt and higher equity. OD. Yes, companies with risk of default tend to have a lower debt and lower equity. O E. No, there does not appear to be a difference between companies with and without risk of default. Click to select your answers). i Financial Information he average debt and average equity for companies with a risk of The database summarizes financial information for 32 companies a default, and also for those without a risk of default. Does there appe B Click the icon to view the financial information for the 32 como: (Round to the nearest whole number as needed.) Use table based calculations to find the average debt for companies The average debt for companies without a risk of default is s7 (Round to the nearest whole number as needed.) Company 1 2 2 3 4 5 Use table-based calculations to find the average equity for compani 8 7 The average equity for companies with a risk of default is $. (Round to the nearest whole number as needed.) 8 Use table-based calculations to find the average equity for compani Category Credit Score Service 604 Manufacturing 714 Manufacturing 732 Manufacturing 792 Service 623 Manufacturing 702 Service 764 Manufacturing 690 Service 802 Service 610 Manufacturing 590 Manufacturing 824 Service 762 Manufacturing 601 Manufacturing 655 Manufacturing 792 Manufacturing 721 Manufacturing 750 Manufacturing 762 Service 598 Manufacturing 742 10 11 12 The average equity for companies without a risk of default is $. (Round to the nearest whole number as needed.) Debt Equity Default Assessment 11,300,165 3,970,452 Yes 3,509,596 2,477,265 No 166,992 1,716,981 No 8,792,444 11,609,806 No 3,296,748 713,827 Yes 13,268,451 4,118,044 Yes 4,985,165 6,314,923 No 7,298,202 5,549,611 No 7,680,789 11,863,030 No 14,857,217 3,918,977 Yes 8,755,636 19,951,799 No 553,914 31,367,969 No 3,118,584 4,664,558 No 1,719,098 349,228 Yes 39,053,934 14,510,564 Yes 4,578,486 4,621,256 No 3,521,635 14,462,865 No 12,697,470 11,369,920 No 5,483,714 18,844,571 No 2,505,940 591,915 Yes 7,319, 156 4,267,330 No 13 33393333 Does there appear to be a difference between companies with and 14 15 16 17 18 O A. Yes, companies with risk of default tend to have a higher de OB. Yes, companies with risk of default tend to have a higher de O c. Yes, companies with risk of default tend to have a lower den OD. Yes, companies with risk of default tend to have a lower den O E. No, there does not appear to be a difference between comp 19 20 21 Click to select your answers). Print Done i Financial Information he average debt and average equity for companies with a risk of The database summarizes financial information for 32 companies a default, and also for those without a risk of default. Does there appe 590 No 11 12 No B Click the icon to view the financial information for the 32 como: (Round to the nearest whole number as needed.) Use table based calculations to find the average debt for companies The average debt for companies without a risk of default is s7 (Round to the nearest whole number as needed.) 13 No Yes 14 Yes 15 16 17 No No Use table-based calculations to find the average equity for compani 18 No The average equity for companies with a risk of default is $. (Round to the nearest whole number as needed.) 19 No Yos Use table-based calculations to find the average equity for compani 20 21 22 No Manufacturing Manufacturing Service Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Service Manufacturing Manufacturing Service Manufacturing Manufacturing Service Manufacturing Manufacturing Service Service Manufacturing Manufacturing 824 782 601 655 792 721 750 762 598 742 821 657 798 695 819 671 771 832 759 613 705 8,755,636 19,961,799 553,914 31,367,969 3,118,584 4,664,558 1,719,098 349,228 39,053,934 14,510,564 4,578,486 4,621,256 3,521,635 14,462,865 12,697,470 11,369,920 5,483,714 18,844,571 2,505,940 591,915 7,319,156 4,267,330 3,731,969 14,304,681 3,876,111 5,445,191 3,250,685 3,473,948 9,631,188 5,578,491 10,439,825 9,086,206 23,531,1596,765,033 9,635,747 6,774,667 11,756,079 13,603,066 828,705 1,674,708 5,986,449 839,302 6,905,334 5,696,860 No The average equity for companies without a risk of default is $. (Round to the nearest whole number as needed.) 23 ZZZZZ Z Z } } } } } } 6 g Yes Does there appear to be a difference between companies with and No No No Yos 24 25 26 27 28 29 30 31 32 No O A. Yes, companies with risk of default tend to have a higher de OB. Yes, companies with risk of default tend to have a higher de O c. Yes, companies with risk of default tend to have a lower den OD. Yes, companies with risk of default tend to have a lower den O E. No, there does not appear to be a difference between comp No No Yes No Click to select your answers). Print Done 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. (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 $7 (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 $C (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 $0. (Round to the nearest whole number as needed.) Does there appear to be a difference between companies with and without a risk of default? O A. Yes, companies with risk of default tend to have a higher debt and higher equity. OB. Yes, companies with risk of default tend to have a higher debt and lower equily. O C. Yes, companies with risk of default tend to have a lower debt and higher equity. OD. Yes, companies with risk of default tend to have a lower debt and lower equity. O E. No, there does not appear to be a difference between companies with and without risk of default. Click to select your answers). i Financial Information he average debt and average equity for companies with a risk of The database summarizes financial information for 32 companies a default, and also for those without a risk of default. Does there appe B Click the icon to view the financial information for the 32 como: (Round to the nearest whole number as needed.) Use table based calculations to find the average debt for companies The average debt for companies without a risk of default is s7 (Round to the nearest whole number as needed.) Company 1 2 2 3 4 5 Use table-based calculations to find the average equity for compani 8 7 The average equity for companies with a risk of default is $. (Round to the nearest whole number as needed.) 8 Use table-based calculations to find the average equity for compani Category Credit Score Service 604 Manufacturing 714 Manufacturing 732 Manufacturing 792 Service 623 Manufacturing 702 Service 764 Manufacturing 690 Service 802 Service 610 Manufacturing 590 Manufacturing 824 Service 762 Manufacturing 601 Manufacturing 655 Manufacturing 792 Manufacturing 721 Manufacturing 750 Manufacturing 762 Service 598 Manufacturing 742 10 11 12 The average equity for companies without a risk of default is $. (Round to the nearest whole number as needed.) Debt Equity Default Assessment 11,300,165 3,970,452 Yes 3,509,596 2,477,265 No 166,992 1,716,981 No 8,792,444 11,609,806 No 3,296,748 713,827 Yes 13,268,451 4,118,044 Yes 4,985,165 6,314,923 No 7,298,202 5,549,611 No 7,680,789 11,863,030 No 14,857,217 3,918,977 Yes 8,755,636 19,951,799 No 553,914 31,367,969 No 3,118,584 4,664,558 No 1,719,098 349,228 Yes 39,053,934 14,510,564 Yes 4,578,486 4,621,256 No 3,521,635 14,462,865 No 12,697,470 11,369,920 No 5,483,714 18,844,571 No 2,505,940 591,915 Yes 7,319, 156 4,267,330 No 13 33393333 Does there appear to be a difference between companies with and 14 15 16 17 18 O A. Yes, companies with risk of default tend to have a higher de OB. Yes, companies with risk of default tend to have a higher de O c. Yes, companies with risk of default tend to have a lower den OD. Yes, companies with risk of default tend to have a lower den O E. No, there does not appear to be a difference between comp 19 20 21 Click to select your answers). Print Done i Financial Information he average debt and average equity for companies with a risk of The database summarizes financial information for 32 companies a default, and also for those without a risk of default. Does there appe 590 No 11 12 No B Click the icon to view the financial information for the 32 como: (Round to the nearest whole number as needed.) Use table based calculations to find the average debt for companies The average debt for companies without a risk of default is s7 (Round to the nearest whole number as needed.) 13 No Yes 14 Yes 15 16 17 No No Use table-based calculations to find the average equity for compani 18 No The average equity for companies with a risk of default is $. (Round to the nearest whole number as needed.) 19 No Yos Use table-based calculations to find the average equity for compani 20 21 22 No Manufacturing Manufacturing Service Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Service Manufacturing Manufacturing Service Manufacturing Manufacturing Service Manufacturing Manufacturing Service Service Manufacturing Manufacturing 824 782 601 655 792 721 750 762 598 742 821 657 798 695 819 671 771 832 759 613 705 8,755,636 19,961,799 553,914 31,367,969 3,118,584 4,664,558 1,719,098 349,228 39,053,934 14,510,564 4,578,486 4,621,256 3,521,635 14,462,865 12,697,470 11,369,920 5,483,714 18,844,571 2,505,940 591,915 7,319,156 4,267,330 3,731,969 14,304,681 3,876,111 5,445,191 3,250,685 3,473,948 9,631,188 5,578,491 10,439,825 9,086,206 23,531,1596,765,033 9,635,747 6,774,667 11,756,079 13,603,066 828,705 1,674,708 5,986,449 839,302 6,905,334 5,696,860 No The average equity for companies without a risk of default is $. (Round to the nearest whole number as needed.) 23 ZZZZZ Z Z } } } } } } 6 g Yes Does there appear to be a difference between companies with and No No No Yos 24 25 26 27 28 29 30 31 32 No O A. Yes, companies with risk of default tend to have a higher de OB. Yes, companies with risk of default tend to have a higher de O c. Yes, companies with risk of default tend to have a lower den OD. Yes, companies with risk of default tend to have a lower den O E. No, there does not appear to be a difference between comp No No Yes No Click to select your answers). Print Done