Use QI Macros to Draw Control Charts Described in

Statistical Process Control - Second Edition, published by AIAG

 

Statistical Process Control - Second Edition ©A popular automotive book on performance measurement is the Statistical Process Control - Second Edition, © 2005 by AIAG (Automotive Industry Action Group). The book covers how to use control charts to analyze and maintain product safety and quality.

It's easy to use QI Macros to create the control charts that feature prominently in the book. If you have installed QI Macros (purchased or trial) you already have an Excel spreadsheet containing many of the data sets described in this book. Look in: My Documents > QI Macros Test Data > AIAG SPC.xlsx.

Watch the videos below to learn how to use QI Macros to create each chart. The page reference for the data used in each video is listed to the right. The book doesn't contain the data for all of the charts, but these should get you started:

XbarR chart - AIAG DIOUEW Length

Median and Range Chart

XmR ImR Chart of Acid Concentration

c chart - AIAG Bolt Defects

np chart - AIAG Spot Weld Flaws

p chart - AIAG Test Discrepancies

u chart - AIAG Dock Audit

XbarR & Histogram of Diameters

To find these data sets from the AIAG Statistical Process Control - 2nd Ed., go to QI Macros Help menu and select Open QI Macros Sample Data.

QI Macros help menu

The file with the data from AIAG can be found near the top.

Data from AIAG Statistical Process Control - Second Edition

Why wait? Start creating these charts and diagrams in seconds using
QI Macros add-in for Excel.