You received partial credit in the previous attempt.

Column H Gross Margin $=$ Sales Price $-$ Cost

Column I Gross Margin Percentage $=$ Gross Margin $$ Sales Price

Management of Skydio thinks that the top $10$ SKUs ranked by gross margin have a significantly different average gross margin than the bottom $10$ SKUs. Using the Data Analysis ToolPak, conduct a hypothesis test using a t$-$test assuming unequal variances to evaluate the premise. Hint: Create a pivot table for average gross margin by SKU; copy the numbers; sort and use the information to identify the $10$ SKUs with the highest gross margins. Answer the following questions based on your hypothesis test.

Required:

a$.$ What is the null hypothesis? What is the alternative hypothesis?

b$.$ What is the average gross margin for the top $10$ SKUs?

c$.$ What is the average gross margin for the bottom $10$ SKUs?

d$.$ What is the $t$ Stat?

e$.$ Assuming that the alpha is set at $0\mathrm{.}05,$ would you reject or not reject the null hypothesis?

f$.$ Assuming that the alpha is set at $0\mathrm{.}01,$ would you reject or not reject the null hypothesis?

g$.$ Is there a statistical difference between the top $10$ and bottom $10$ SKUs ranked by gross margin?

Complete this question by entering your answers Yn the tabs below.

Req $B$ and $C$

Req D

Req $E$ and $F$

What is the $t$ Stat?

Note: Round your answer to $3$ decimal places.

t Stat