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:
Open AIAG SPC.xls
Open Healthcare SPC.xls
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.
Click here to Download SPC-exercises.zip.
Right click to extract and follow instructions in each file.