Type this in excel and then paste here. Thanks. Day 1 2 3 4 5 6 7

Type this in excel and then paste here. Thanks.

 

Transcribed Image Text:

Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Customers 15.00 18.00 9.00 7.00 19.00 30.00 27.00 13.00 11.00 9.00 21.00 35.00 25.00 8.00 16.00 21.00 17.00 22.00 16.00 24.00 14.00 15.00 21.00 27.00 17.00 21.00 20.00 31.00 38.00 42.00 Time 1.50 1.20 0.80 0.50 2.00 2.50 3.00 2.00 1.70 0.50 2.00 5.20 2.30 0.20 0.70 2.50 1.00 3.80 1.50 2.80 1.00 1.70 3.00 2.80 1.00 2.50 2.90 3.40 4.00 4.80 A critically important aspect of customer service in a supermarket is the waiting time at the checkout (defined as the time the customer enters the line until he or she is served). Data were collected during time periods in which a constant number of checkout counters were open. The total number of customers in the store and the waiting time (in minutes) were recorded. 1. Determine the coefficient of determination, and interpret its meaning. 2. How useful do you think this regression model is for predicting wait time at the checkout line? 3. Suppose you just implemented an improvement project where you attempted to improve wait time at the checkout in a supermarket and these are your findings. What would you conclude about your study? (150 words) Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Customers 15.00 18.00 9.00 7.00 19.00 30.00 27.00 13.00 11.00 9.00 21.00 35.00 25.00 8.00 16.00 21.00 17.00 22.00 16.00 24.00 14.00 15.00 21.00 27.00 17.00 21.00 20.00 31.00 38.00 42.00 Time 1.50 1.20 0.80 0.50 2.00 2.50 3.00 2.00 1.70 0.50 2.00 5.20 2.30 0.20 0.70 2.50 1.00 3.80 1.50 2.80 1.00 1.70 3.00 2.80 1.00 2.50 2.90 3.40 4.00 4.80 A critically important aspect of customer service in a supermarket is the waiting time at the checkout (defined as the time the customer enters the line until he or she is served). Data were collected during time periods in which a constant number of checkout counters were open. The total number of customers in the store and the waiting time (in minutes) were recorded. 1. Determine the coefficient of determination, and interpret its meaning. 2. How useful do you think this regression model is for predicting wait time at the checkout line? 3. Suppose you just implemented an improvement project where you attempted to improve wait time at the checkout in a supermarket and these are your findings. What would you conclude about your study? (150 words)

Answer rating: 100% (QA)

1 The coefficient of determination is 087 which means that the wait time at ... View the full answer