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.

Automotive

Open My Documents\QI Macros Test Data\AIAG SPC.xls

Healthcare

Open My Documents\QI Macros Test Data\Healthcare SPC.xls

Exercises

1. Run Control Charts on XbarR and XmR data.

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.

Pareto Chart Excel for Six Sigma

Manufacturing

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



Recommended Books by Jay Arthur