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.xlsx
Open Healthcare SPC.xlsx
- Run Control Charts on XbarR and XmR data.
Extra credit: Run the Control Chart Wizard on your defect data. Discuss with your coworkers.
- Run Histograms on XbarR and XmR data. Use USL/LSL when supplied; Use Cancel when none.
- Evaluate each data set for stability and capability.
- Run Control Charts on c, p, np, and u data.
- 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.