SPC Exercise Dojo
Load QI Macros 30-day trial. Then find the test data loaded on your computer in your My Documents folder.
Open My Documents\QI Macros Test Data\AIAG SPC.xls
Open My Documents\QI Macros Test Data\Healthcare SPC.xls
1. Run Control Charts on XbarR and XmR data.
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.
Click here to Download SPC-exercises.zip.
Right click to extract and follow instructions in each file.