In order to increase time spent shopping in its stores, a large retail chain recently updated the general layout and design of its stores. A previous study conducted 5 years ago found that the average time shoppers spent in their stores was 20 minutes. Recent changes included updating the look or theme as well as the layout of the store and the location of items. The data below represent the number of minutes twelve customers spent shopping in their stores from a study conducted one month ago: Minutes Spent Shopping: 28 18 37 20 22 31 15 35 40 28 25 30a) (2 points) What is the estimated standard error of the mean for the minutes spent shopping data above ? b) (5 points) Provide an interpretation for the SEM obtained in 'part A. c) (2 points) What is being compared in the description above? d) (5 points) State the null hypothesis for the time spent shopping problem described above. e) (3 points) Conduct a test of the null hypothesis (p = .05) using the one-sample t-test. You must show all work in order to receive any credit. BE SURE TO PROPERLY STATE YOUR STATISTICAL CONCLUSION - "Since t() = ....... " f) (5 points) Provide an interpretation of your statistical conclusion from part E. g) (1 point) Based on your statistical conclusion in part E, what type of statistical error may have been made? h) (2 points) How could have the researcher increase statistical power for this study? i) (5 points) Using the Descriptive Statistics function in Excel, obtain the 95% condence interval for the minutes spent shopping data above. 1) (5 points) Provide an interpretation for the 95% condence interval obtained in part I. A B C D E F Minutes Spent Shopping: 2 3 Mean 27.41666667 95% Confidenceterval 4 Standard Error 2.237620264 5 Median 28 Lower Limit 22.49169767 6 Mode 28 7 Standard Deviation 7.751343969 Upper Limit 32.34163566 Sample Variance 60.08333333 9 Kurtosis 0.865402935 10 Skewness 0.009834747 11 Range 25 12 Minimum 15 13 Maximum 40 14 Sum 329 15 Count 12 16 Confidence Level(95 4.924968994 17 18 Sheet2 Sheet1 +