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?

LOADING... Click the icon to view the financial information for the $32$ companies.

Question content area bottom

Part $1$

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 $$$

$$

enter your response here.

$($Round to the nearest whole number as$$ needed.$)$

Part $2$

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 $$$

$$

enter your response here.

$($Round to the nearest whole number as$$ needed.$)$

Part $3$

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 $$$

$$

enter your response here.

$($Round to the nearest whole number as$$ needed.$)$

Part $4$

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 $$$

$$

enter your response here.

$($Round to the nearest whole number as$$ needed.$)$

Part $5$

Does there appear to be a difference between companies with and without a risk of$$ default?

A$.$

$$No$,$ there does not appear to be a difference between companies with and without risk of default.

B$.$

$$Yes$,$ companies with risk of default tend to have a higher debt and higher equity.

C$.$

$$Yes$,$ companies with risk of default tend to have a lower debt and lower equity.

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 higher equity.