Question: Please answer using Excel (25 points) A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly

Please answer using Excel Please answer using Excel (25 points) A teller at

(25 points) A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly selected customers: SAMPLE 2 3 1 4 4.5 4.2 4.2 4.3 4.3 4.6 4.5 4.4 4.7 4.3 4.5 4.6 4.4 4.4 4.6 4.7 4.6 4.8 45 4.9 a. Determine the mean of each sample. If the process parameters are unknown, estimate its mean and standard deviation. Estimate the mean and standard deviation of the sampling distribution. b. What would three-sigma control limits for the process be? c. What alpha risk would control limits of 4.14 and 4.86 provide? d. Using limits of 4.14 and 4.86, are any sample means beyond the control limits? If so, which one(s)? e. Construct control charts for means and ranges using Table 10.3. Are any samples beyond the control limits? If so, which one(s)? f. If the process has a known mean of 4.4 and a known standard deviation of .18, what would three-sigma control limits be for a mean chart? Are any sample means beyond the control limits? If so, which one(s)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Chapter 10: Question #20 ONLY ANSWER parts e,f,g,h,i (Please answer using Excel) Thanks! 0. A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly...

Can you show the work? Plz A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly selected customers: What is sX? Select one: a. 0.007368 b. 0.08584 c....

A teller at a drive-up window at a bank had the following service times in minutes) for 20 randomly selected customers: SAMPLE 1 2 3 4 4.5 4.6 4.5 4.7 4.2 4.5 4.6 4.6 4.2 4.4 4.4 4.8 4.3 4.7 4.4 4.5...

A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly selected customers: SAMPLE: Construct control charts for ranges and means using the following...

12. A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly selected customers: SAMPLE 1 2 3 4 4.5 4.6 4.5 4.7 4.2 4.5 4.6 4.6 4.2 4.4 4.4 4.8 4.3 4.7 4.4...

A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly selected customers: SAMPLE 1 2 3 4 4.5 4.6 4.5 4.7 4.2 4.5|4.6 4.6 4.2 4.44.4 4.8 4.3 4.74.4 4.5...

hello can you help me with this Chapter 5 Problem 1 A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being...

there is no other information I can add. what you see in the picuture is the entire problem. A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly...

Could you please answer and show calculations 20. A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly selected customers. SAMPLE 1 2 4 4.5 4.6 4.5 4.7...

A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly selected customers: SAMPLE 3 1 2 4 4.5 4.6 4.5 4.7 4.2 4.5 4.6 4.6 4.2 4.4 4.4 4.8 4.3 4.7 4.4 4.5...

As used by the GASB, interperiod equity refers to which of the following? Financial reporting should: a) Demonstrate compliance with finance-related contractual requirements. b) Provide information...

Applying the net present value approach with and without tax considerations Luther Currie, the president of Luther's Moving Services, Inc., is planning to spend $625,000 for new trucks. He expects...

equatedauta entify the three parts of the Lemon test. Correct Answer ( s ) q , Does the practice foster an excessive government entanglement with religion?

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...