Question: Need to know how to do this within Excel. At a Florida orange juice producer, they have been studying the time it takes to prepare

Need to know how to do this within Excel.
At a Florida orange juice producer, they have been studying the time it takes to prepare an independent hauler truck for shipment. This process begins when the production department notifies the traffic department to arrange for an independent hauler for a juice shipment. When the truck arrives at the plant, the truck's information is entered into the company's computerized tracking system. This paperwork includes information on previous loads and tank wash records. This step is expected to take 25 minutes on average. The sample size is 5. A Construct X Bar and S Chart Does the process under control? Why or why not? B S X Bar 27 1 2 2 2 2.7 27 3 3 26.5 4 2.7 28 5 2 25.5 6 3 27.5 7 1.5 25 8 1.6 25.5 9 0.5 28 10 2.5 26 11 4.7 26 1.3 26.5 12 13 2.5 25.5 14 6 25 15 26.5 5.5 4.4 16 25 17 2 28.5 18 0.5 28 19 2.5 26.5 20 1 24.5Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
