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. Click on QI Macros Help to open the test data:

QI Macros Test Data Menu

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.

    control chart
  2. Run Histograms on XbarR and XmR data. Use USL/LSL when supplied; Use Cancel when none.

    histogram
  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.
    Pareto

Manufacturing

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



Books by Jay Arthur