Reference no: EM132856333

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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Reading 104.4 102.4 105.5 107.6 107.4 108.5 100.6 104.5 107.2 102.8 103.6 101.6 101.3 103 103.5 100.8 103.9 104.2 105.3 104.3 103.3 102.8 101.3 102.1 100.1 101.8 100 99.6 100.9 99.8 98.6 100.4 99 101.3 100.8 99.2 100.5 98.9 98.9 98.6 100.2 101.5 98.5 100.2 99.9 100.1 99.2 98.5 102.1 100.5

A team is working on improving the process for manufacturing parts. They think the control limits for the diameter of the part need recalculation. The individual parts diameter readings for the last 50 days are collected. The specification for the diameter of the parts is 100 ±10 (90 - 110). Create the control charts. Analyze the outcomes and provide recommendations.

Please use excel and explain in detail.