IIl CUSUM Chart Creation (15 pts) ovtion Create a two-sided cumulative sum chart
ID: 3319682 • Letter: I
Question
IIl CUSUM Chart Creation (15 pts) ovtion Create a two-sided cumulative sum chart for the following data on the successive measurements on the dimensions of a telephone cable (in mm) with Target value of 250 mm and process standard deviation of 1.5 mm. The CUSUM chart should be designed to detect a shift of 1 standard deviation from the target. Construct cusum limits to detect H-5 times the standard deviation. 9 ITEM Measurement 251.41 253.45 248.42 249.19 247.82 251.94 247.32 247.56 250.25 248.09 ITEM Measurement 11 251.41 12 252.38 13 254.29 14 253.74 15250.07 16 253.3 17 250.84 18 253.94 19 252.09 20 251.3 10Explanation / Answer
We can calculat two sided cumulative sum as follows :
Take first value as it is , for next take first value of cumulative sum and add next value in that .
same as for all next values .
And for the cumulative sum of decreasing order , take last value as it is and to find 2nd last value , take last value and add 2nd last value from given data .
It gives output as :
Item Measurement Cumsum1 Cumsum2 1 251.41 251.41 5018.81 2 253.45 504.86 4767.4 3 248.42 753.28 4513.95 4 249.19 1002.47 4265.53 5 247.82 1250.29 4016.34 6 251.94 1502.23 3768.52 7 247.32 1749.55 3516.58 8 247.56 1997.11 3269.26 9 250.25 2247.36 3021.7 10 248.09 2495.45 2771.45 11 251.41 2746.86 2523.36 12 252.38 2999.24 2271.95 13 254.29 3253.53 2019.57 14 253.74 3507.27 1765.28 15 250.07 3757.34 1511.54 16 253.3 4010.64 1261.47 17 250.84 4261.48 1008.17 18 253.94 4515.42 757.33 19 252.09 4767.51 503.39 20 251.3 5018.81 251.3