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 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
Get step-by-step solutions from verified subject matter experts
