Best Buy has been examining customer satisfaction with their Geek Squad service support. A random sample...

  

Transcribed Image Text:

Best Buy has been examining customer satisfaction with their Geek Squad service support. A random sample 350 customers in each of 15 stores around the Northeast to question them on whether or not they were satisfied with their Geek Squad service. The following data has been collected: STORE 12 3 & in 4 5 6 10 11 12 13. 14 15 # DISSATISFIED CUSTOMERS 14 25 24 20 18 27 16 17 12 7 17 15 17 14 10 SAMPLE SIZE 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 Copy the data into a new Excel worksheet and complete the following: 1. Calculate the percent of customers sampled that were dissatisfied with their Geek Squad service. 2. What type of control chart should be created to evaluate the data? 3. Find the center line, UCL and LCL for a 95 percent confidence (use Z-1.96) control chart. 4. Is the process in control? What does this tell you about consistency of the Geek Squad across the stores? Which stores are an issue? Best Buy has been examining customer satisfaction with their Geek Squad service support. A random sample 350 customers in each of 15 stores around the Northeast to question them on whether or not they were satisfied with their Geek Squad service. The following data has been collected: STORE 12 3 & in 4 5 6 10 11 12 13. 14 15 # DISSATISFIED CUSTOMERS 14 25 24 20 18 27 16 17 12 7 17 15 17 14 10 SAMPLE SIZE 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 Copy the data into a new Excel worksheet and complete the following: 1. Calculate the percent of customers sampled that were dissatisfied with their Geek Squad service. 2. What type of control chart should be created to evaluate the data? 3. Find the center line, UCL and LCL for a 95 percent confidence (use Z-1.96) control chart. 4. Is the process in control? What does this tell you about consistency of the Geek Squad across the stores? Which stores are an issue?

Answer rating: 100% (QA)

To analyze the data and answer the questions lets perform the calculations and interpret the results step by step 1 Calculate the percent of customers ... View the full answer