Page 170 - Lean six sigma demystified
P. 170

Chapter 4  e xC e L   Power  Too LS   for   Lean   Six   Sigm a        149


                    ExErcisEs


                           1.  Install the QI Macros.

                           2.  Practice running all of the charts using data in c:\qimacros\testdata.
                              •   data.xls—bar, pie, line, or run chart
                              •   pareto.xls—Pareto chart
                              •   scatter.xls—scatter diagram
                              •   matrixplot.xls–matrix plot
                              •   histogram.xls—histogram (use the specification limits provided).
                              •   c, np, p, or, u chart.xls—attribute control charts (c, np, p, u)
                              •   XmR chart, XbarR, XbarS.xls—variable control charts
                              •   AIAG SPC.xls—attribute and variable control charts for the automotive industry
                              •   Healthcare SPC.xls—attribute and variable control charts for health care

                           3.  Control chart templates
                              •   Click on Fill-in-the-Blanks templates and choose c, np, p, u, XmR, XbarR, or XbarS.
                              •   Copy data from the test-data files and paste it into these templates.
                              •   XmR or c, p, u dashboards for tracking multiple measures.

                           4.  Drawing templates
                              •   Click on Fill-in-the-Blanks templates and choose flowchart, value stream map,
                                or value-added flow analysis.
                              •   Practice using the drawing toolbar to move objects around (View–Toolbars–
                                Drawing).
   165   166   167   168   169   170   171   172   173   174   175