Use table-based calculations to find the average credit score, 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?

**please be sure to do step by step and make sure to write down the formulas used in your excel sheet.

Corporate Default Database
Company	Category	Credit Score	Payment delay in last 3 months?	Debt	Equity	Profit/Loss	Amount	Default Assessment
1	Service	604	Yes	$ 11,672,388.00	$3,742,284	Profit	$336,024	Yes
2	Manufacturing	714	No	$3,294,252	$2,391,324	Profit	$298,584	No
3	Manufacturing	732	No	$192,816	$1,574,352	Profit	$704,496	No
4	Manufacturing	792	No	$8,778,744	$11,463,348	Profit	$3,208,764	No
5	Service	623	No	$3,206,736	$710,580	Loss	$159,588	Yes
6	Manufacturing	702	No	$13,018,512	$4,048,356	Loss	$66,924	Yes
7	Service	764	No	$4,485,312	$6,107,868	Profit	$752,076	No
8	Manufacturing	690	No	$7,813,104	$5,870,904	Profit	$801,528	No
9	Service	802	No	$7,149,948	$11,444,628	Profit	$2,864,004	No
10	Service	610	No	$14,759,472	$3,911,232	Loss	$1,560,312	Yes
11	Manufacturing	590	Yes	$8,254,740	$19,771,284	Profit	$2,003,352	No
12	Manufacturing	824	No	$542,568	$31,290,168	Profit	$11,336,832	No
13	Service	762	No	$873,600	$4,524,000	Loss	$66,456	No
14	Manufacturing	601	No	$1,631,604	$320,112	Profit	$34,164	Yes
15	Manufacturing	655	Yes	$32,253,936	$14,777,724	Loss	$407,472	Yes
16	Manufacturing	792	No	$4,853,472	$4,532,736	Profit	$751,452	No
17	Manufacturing	721	No	$3,705,468	$14,046,552	Profit	$5,451,264	No
18	Manufacturing	750	No	$12,623,676	$11,253,060	Profit	$1,446,432	No
19	Manufacturing	762	No	$5,384,340	$18,725,616	Profit	$1,257,048	No
20	Service	598	Yes	$2,764,788	$534,924	Profit	$76,752	Yes
21	Manufacturing	742	No	$7,101,588	$4,167,228	Profit	$409,032	No
22	Manufacturing	821	No	$3,923,088	$14,434,524	Loss	$1,872	No
23	Service	657	No	$3,950,544	$5,349,084	Loss	$264,732	Yes
24	Manufacturing	798	No	$3,341,988	$3,121,872	Profit	$2,698,176	No
25	Manufacturing	695	No	$9,971,208	$5,556,252	Profit	$784,524	No
26	Service	819	No	$10,583,508	$9,030,684	Profit	$6,391,476	No
27	Manufacturing	671	No	$23,596,092	$6,685,692	Loss	$51,324	Yes
28	Manufacturing	771	No	$9,741,576	$6,742,788	Profit	$1,077,024	No
29	Service	832	No	$11,858,496	$13,613,652	Profit	$533,988	No
30	Service	759	No	$895,128	$1,894,932	Profit	$163,332	No
31	Manufacturing	613	No	$5,965,440	$828,672	Loss	$146,796	Yes
32	Manufacturing	705	No	$6,745,908	$5,966,220	Profit	$878,280	No