SPC Exercise Dojo

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:

Automotive

Open AIAG SPC.xlsx

Healthcare

Open Healthcare SPC.xlsx

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.
   
   
   
2. Run Histograms on XbarR and XmR data. Use USL/LSL when supplied; Use Cancel when none.
   
   
   
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.
   

Manufacturing

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