Type this in excel and then paste here. Thanks. Day 1 2 3 4 5 6 7
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Expert Answer:
Answer rating: 100% (QA)
1 The coefficient of determination is 087 which means that the wait time at ... View the full answer
Related Book For
Managerial Economics
ISBN: 978-0133020267
7th edition
Authors: Paul Keat, Philip K Young, Steve Erfle
Posted Date:
Students also viewed these abstract writing questions
-
Problem 1. A) Determine the MARR for a company that can invest excess funds at 6% and requires 7% profit margin. B) What if, instead, the company borrows funds at 9%? a) MARR 13.00% b) MARR 16.00%
-
A square footing on sand is subjected to an eccentric load, as shown in Figure 17.24. Using Meyerhofs effective area oncept, determine the gross allowable load that the footing could carry with F s =...
-
1. What is your opinion of the level at which the data are being collected? What are some of the advantages of collecting data at this level? 2. Aggregate the original data for October as you see...
-
You work as a manager in the admission department of company. You were asked by your department head to present and analyze the qualifying test scores of 40 employees who are applying for 5-year...
-
a. If Montreal wants to pursue the objective of minimizing the distance the snow must be moved (and therefore the cost of removing snow), how much snow should it plan to move from each sector to each...
-
John Roberts is 55 years old and has been asked to accept early retirement from his company. The company has offered John three alternative compensation packages to induce John to retire: 1. $180,000...
-
What superseded SAS No. 82?
-
Book and liquidation value The balance sheet for Gallinas Industries is as follows. Additional information with respect to the firm is available: (1) Preferred stock can be liquidated at book value....
-
Can someone please help me solve these problems Question Completion Status: Great Window A Moving to another question will save this response. Question 1 of 148 Question 1 4 points Save Actioner A...
-
Your tax clients, Jack and Diane a married couple filing a joint return, fell in love with a new construction house for sale in their small Illinois hometown. The builder offers two options on the...
-
3 ) Think of an example ( any source or process, hypothetical or real ) in which the change of energy is approximately 1 J . Give another example in which the energy changes by 1 kJ , and a third...
-
A. For the following code fragments and expressions, give the proper big O notation: Code Fragments or expressions # 1 2n + n+ 13 0 (?) 2 int x =0; while (x
-
Prepare a comparison of the vendors. Specify the types of software and services they provide. Do any of the vendors identify their experience in specific industries, types or sizes of firms? Consider...
-
Bramblett Recording Studio is considering two investment proposals (1 and 2). Data for the two proposals are presented below: Cost of investment Estimated salvage value Average estimated net income...
-
Research three possible cars for purchase. --Tesla, BMW X3, and Honda Civic Write up your comparison and discuss your process, what criteria you used in determining your best fit, and your overall...
-
Explain the importance of the importance of business intelligence and how it can successfully aid organizations in being competitive. Please cover the following at least: two different types of...
-
BE 25-3 Make or Buy Obj. 1 A company manufactures various-sized plastic bottles for its medicinal product. The manufacturing cost for small bottles is $30 per unit (1,000 bottles), including fixed...
-
Interest Compounded Annually. When P dollars is invested at interest rate i, compounded annually, for t years, the investment grows to A dollars, where A = P(1 + i) t . Trevor's parents deposit $7800...
-
Explain why a firm's adherence to the MRP = MFC rule enables it to find the optimal number of units of a variable input to use in the short-run production process.
-
Define returns to scale. Why is this considered a long-run phenomenon?
-
a. Why are manufacturers' new orders, nondefense capital goods, an appropriate leading indicator? b. Why is the index of industrial production an appropriate coincident indicator? c. Why is the...
-
Jackson Sales Company has prepared the following budgets for the second quarter of 2005: Required: Prepare a cash payment schedule for the second quarter of 2005. Jackson Sales Company Selling and...
-
The following budgeted information is available for the Top Coat Clothing Company for January 2005. Selling and administrative expenses are paid in the month incurred and purchases are paid in the...
-
The following budgeted information is available for Jacks Feed Store in June 2005. Selling and administrative expenses are paid in the month incurred and purchases are paid in the month following the...
Study smarter with the SolutionInn App