Consumer Reports uses a 100-point customer satisfaction score to r pplation stan

Question

Consumer Reports uses a 100-point customer satisfaction score to r pplation standard deviation of · 2 s expected. Costco thes 432 warehouses n 40 states was the um chats oepas expen of 15 Costco scores is contained in the Excel Online file below. Construct a that from onl spreadsheet to answer the following questions on reting score, a d. Construct a hypothesis test to determine-hether the population standard deviation of -12 should be reected for Costco. State the null and alternative hypotheses 144 Calculate the value of the test statistic (to 2 decimals) p-value is with a 05 level of significance, what is your conclusion? The hypothesis that the population standard deviation is 12 O Type here to ind 2 2 9

Explanation / Answer

satisfaction score 93 a) 90 mean 84.33333 84 75 b) 95 variance 120.2381 99 80 c) 83 standard deviation 10.96531 81 94 d) 89 df 14 80 sd under null 12 95 TS 11.68981 66 61 0.631197 5.628726103 lower critical value 0.368803 26.11894805 upper critical value cannot be rejected satisfaction score 93 a) 90 mean =AVERAGE(A2:A16) 84 75 b) 95 variance =VAR(A2:A16) 99 80 c) 83 standard deviation =STDEV(A2:A16) 81 94 d) 89 df =14 80 sd under null 12 95 TS =D12*D6/D13^2 66 61 =CHISQ.DIST.RT(D14,D12) =CHISQ.INV(0.025,14) lower critical value =CHISQ.DIST(D14,14,1) =CHISQ.INV(0.975,14) upper critical value cannot be rejected

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.