I need help finding the answers to the questions in the attached document. Please explain the best way to complete using the data found in the attached document.

Consumer Reports uses a 100-point customer satisfaction score to rate the nation's major chain stores. Assume that from past experience with the satisfaction rating score, a population standard deviation of 0' = 12 is expected. Costco with its 432 warehouses in 40 states was the only chain store to earn an outstanding rating for overall quality. A sample of 15 Costco customer satisfaction scores is contained in the Excel Online le below. Construct a spreadsheet to answer the following questions. Open spreadsheet a. What is the sample mean customer satisfaction score for Costco (to 2 decimals)? b. What is the sample variance (to 2 decimals)? c. What is the sample standard deviation (to 2 decimals)? d. Construct a hypothesis test to determine whether the population standard deviation of 0' = 12 should be rejected for Costco. State the nul and alternative hypotheses. H0 : 02 = 144 H... :02 v 144 Calculate the value of the test statistic (to 2 decimals). pvalue is With a .05 level of signicance, what is your conclusion? The hypothesis that the population standard deviation is 12 V . A B C D E F Satisfaction H Score Part a Formula 96 Mean #N/A 90 85 Part b VOUAWN 74 Variance #N/A 95 99 Part c 8 80 Standard Deviation #N/A 9 80 10 84 Part d 11 92 Degrees of Freedom #N/A 12 87 13 80 Hypothesized Standard Deviation 12 14 95 15 64 Chi Square Test Statistics #N/A 16 62 17 Lower-Tail p-value #N/A 18 Upper-Tail p-value #N/A 19 Two-Tail p-value #N/A 20 21 Significance Level (alpha) 0.05 22 Can the hypothesis that the population standard deviation is 12 be rejected? (Enter 23 "Can be rejected" or "Cannot be rejected") #N/A 24 25 26