(Answered):Week 5 Case Study Excel Spreadsheet . . . .

Question Description

You are the manager of a retail store. You want to investigate how metrics can improve the way you manage your business.

Using the Week 5 Data Set, create and calculate the following in Microsoft® Excel®:

1. Conduct a goodness of fit analysis which assesses orders of a specific item and items you received by size, and do the following:
   • Conduct a hypothesis test with the objective of determining if there is a difference between what you ordered and what you received at the .05 level of significance.
   • Identify the null and alternative hypotheses.
2. Generate a scatter plot, the correlation coefficient, and the linear
   OR

    

   PayPal Gateway not configured

   OR

    

   PayPal Gateway not configured