he 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? Company Category Credit Score Debt Equity Default Assessment 1 Service 604 10,644,614 3,975,798 Yes 2 Manufacturing 714 4,787,980 2,120,721 No 3 Manufacturing 732 179,433 1,785,756 No 4 Manufacturing 792 8,464,689 11,939,364 No 5 Service 623 3,273,638 779,720 Yes 6 Manufacturing 702 13,367,369 4,392,888 Yes 7 Service 764 4,117,031 6,145,790 No 8 Manufacturing 690 7,356,986 5,853,539 No 9 Service 802 7,283,191 11,667,373 No 10 Service 610 14,899,343 3,939,546 Yes 11 Manufacturing 590 8,731,914 19,948,036 No 12 Manufacturing 824 577,722 31,488,366 No 13 Service 762 8,637,970 4,570,078 No 14 Manufacturing 601 1,617,525 304,560 Yes 15 Manufacturing 655 37,204,986 14,638,258 Yes 16 Manufacturing 792 4,615,531 4,510,496 No 17 Manufacturing 721 3,877,232 14,280,194 No 18 Manufacturing 750 12,876,803 11,404,099 No 19 Manufacturing 762 5,325,191 18,853,412 No 20 Service 598 2,563,100 557,595 Yes 21 Manufacturing 742 7,477,671 4,337,932 No 22 Manufacturing 821 3,786,924 14,410,750 No 23 Service 657 3,772,201 5,039,558 Yes 24 Manufacturing 798 3,278,342 3,279,530 No 25 Manufacturing 695 9,606,347 5,529,420 No 26 Service 819 10,360,418 9,195,252 No 27 Manufacturing 671 23,660,282 6,625,997 Yes 28 Manufacturing 771 9,926,568 6,775,854 No 29 Service 832 11,631,990 13,523,402 No 30 Service 759 897,510 1,595,232 No 31 Manufacturing 613 5,959,887 804,650 Yes 32 Manufacturing 705 6,652,699 5,654,049 No
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?
Company Category Credit Score Debt Equity Default Assessment
1 Service 604 10,644,614 3,975,798 Yes
2 Manufacturing 714 4,787,980 2,120,721 No
3 Manufacturing 732 179,433 1,785,756 No
4 Manufacturing 792 8,464,689 11,939,364 No
5 Service 623 3,273,638 779,720 Yes
6 Manufacturing 702 13,367,369 4,392,888 Yes
7 Service 764 4,117,031 6,145,790 No
8 Manufacturing 690 7,356,986 5,853,539 No
9 Service 802 7,283,191 11,667,373 No
10 Service 610 14,899,343 3,939,546 Yes
11 Manufacturing 590 8,731,914 19,948,036 No
12 Manufacturing 824 577,722 31,488,366 No
13 Service 762 8,637,970 4,570,078 No
14 Manufacturing 601 1,617,525 304,560 Yes
15 Manufacturing 655 37,204,986 14,638,258 Yes
16 Manufacturing 792 4,615,531 4,510,496 No
17 Manufacturing 721 3,877,232 14,280,194 No
18 Manufacturing 750 12,876,803 11,404,099 No
19 Manufacturing 762 5,325,191 18,853,412 No
20 Service 598 2,563,100 557,595 Yes
21 Manufacturing 742 7,477,671 4,337,932 No
22 Manufacturing 821 3,786,924 14,410,750 No
23 Service 657 3,772,201 5,039,558 Yes
24 Manufacturing 798 3,278,342 3,279,530 No
25 Manufacturing 695 9,606,347 5,529,420 No
26 Service 819 10,360,418 9,195,252 No
27 Manufacturing 671 23,660,282 6,625,997 Yes
28 Manufacturing 771 9,926,568 6,775,854 No
29 Service 832 11,631,990 13,523,402 No
30 Service 759 897,510 1,595,232 No
31 Manufacturing 613 5,959,887 804,650 Yes
32 Manufacturing 705 6,652,699 5,654,049 No
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 7 images
