Question: PLEASE DO THIS IN EXCEL An ice cream maker, Bama Creamery (BC), should control the amount of carbs in its low-carb products for the balance

PLEASE DO THIS IN EXCEL An ice cream maker, Bama Creamery (BC),should control the amount of carbs in its low-carb products for thebalance between taste and healthiness. The average carb in its low-carb productsPLEASE DO THIS IN EXCEL

An ice cream maker, Bama Creamery (BC), should control the amount of carbs in its low-carb products for the balance between taste and healthiness. The average carb in its low-carb products is known to be =18.25 grams with standard deviation of =0.57gram. BC has taken samples for the past 20 days to monitor the amount of carbs and the collected data is given in the following table. Find the 3-upper control limit (UCL) for Phase II X chart. (Round to 2 decimal places) Find the 3-lower control limit (LCL) for Phase II X chart. (Round to 2 decimal places) If you construct the Phase II X chart based on the work above, then it will suggest that the process is

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!