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.
Step by Step Answer:
Introduction To Business Analytics
ISBN: 9781265454340
1st Edition
Authors: Vernon Richardson, Marcia Watson