Management of Skydio thinks that the top 10 SKUs ranked by gross margin have a significantly different

Question:

Management of Skydio thinks that the top 10 SKUs ranked by gross margin have a significantly different average gross margin than the bottom ten SKUs. Using the Data Analysis ToolPak, conduct a hypothesis test using a t-test assuming unequal variances to evaluate the premise.

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.05, would you reject or not reject the null hypothesis?

f. Assuming that the alpha is set at 0.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? Evaluate the results of the hypothesis test.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Introduction To Business Analytics

ISBN: 9781265454340

1st Edition

Authors: Vernon Richardson, Marcia Watson

Question Posted: