SPC Exercise Dojo

Sample Problems

Load QI Macros 30-day trial. Then find the test data loaded on your computer in your My Documents folder. Click on QI Macros Help to open the test data:
QI Macros Test Data Menu

Automotive

Open AIAG SPC.xls

Healthcare

Open Healthcare SPC.xls

Exercises

1. Run Control Charts on XbarR and XmR data.
Extra credit Run the Control Chart Wizard on your defect data. Discuss with your coworkers.

Control Chart Excel

2. Run Histograms on XbarR and XmR data. Use USL/LSL when supplied; Use Cancel when none.

Histogram Excel

3. Evaluate each data set for stability and capability.

4. Run Control Charts on c, p, np, and u data.

5. Evaluate each data set for stability.

Extra credit (Automotive data): Run Pareto charts on total defects for c, np, p and u data.
Extra-extra credit Run Pareto charts on your data. Discuss with your coworkers.

Pareto Chart Excel for Six Sigma

Manufacturing

Click here to Download SPC-exercises.zip.
Right click to extract and follow instructions in each file.



Books by Jay Arthur