Statistics

Decision Making Under Uncertainty, GENG 623 Project 6 Due Date: 4/20/2017 Consider a process with a mean value of 20, upper control limit (UCL) of 30 and lower control limit (LCL) of 10. Plot the following points and determine if the process is in statistical control. If not, divide the process into groups based on 5 equal time intervals and determine which group has out of control condition. Also indicate what type of Out-Of-Control condition is applicable to each group. Time Process value Time Process value 1 18 31.5 18 2.5 23 32 14.5 3.5 17.5 34 18.5 5 23 35.5 22.5 6 16 37 19 7.5 24 38.5 22 10 27 39 19 13 32 40 22 14.5 24 41 18 16.5 19 42.5 23 19 15 43 17.5 20 21 44 19 21.5 18.5 45.5 19.5 23 23 46 21.5 25 19 47.5 23 26.5 27 48 19 29 31 49.5 17 30 25 50 19 31 22 If this process is six standard deviation (6 ), determine the various capability indexes (Cp, Cpk, and Cpm). For Cpm assume a target value of 21. Submit Excel spreadsheet and a Word document to explain the procedure used to create Excel spreadsheet.