For the Control Chart Assignment you will have a chance to practice your skills by creating and analyzing control charts for 5 different sample readings. Use Excel template provided and the Sample Data 1 to answer Q1, Sample Data 2 to answer Q2 etc. You will enter the sample data representing the number of defect into the Green Shaded Cells.
The spreadsheet is set up to calculate the following key elements of information that you can use to analyze what is going on with each process scenario.
For this exercise you are the PM for your project and have taken a series of 15 readings over 15 days to measure the number of defects in your process. Once you enter the data set the spreadsheet will generate the control chart plot.
For each of the 5 scenarios perform the calculations, and then interpret the control chart and state if the process is in control or not along with supporting rational. Include a screen shot of your plot when discussing your analysis for each scenario.
Your analysis should also include comments and observations on the process when the Z value (Sets the Control Limits) is changed. What if you move from 2 to 3? What is the impact?
Control Chart Exercise (Student)-1.xlsx Download Control Chart Exercise (Student)-1.xlsx
Refer to the 8 tests (or rules) in the lecture slides and on pages 133-135 of Pocket Toolbook.
When using the spreadsheet:
The Z value sets where the control lines are drawn in the graph. The results box lists the standard deviation. If you change the Z value to 1 you will see that the control limits are drawn at 1 standard deviation which represents Zone c. If you change the Z value to 2 the control limits are drawn to outline the B zone and 3 the A zone. You can change the Z values to outline the Zones and make it easier to apply the 8 Shewart (Western Electric) Rules to each data set to determine if the data is out of control and if it is by what rule.
Let me know if you have any questions.
