Page 168 - Lean six sigma demystified

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

Quiz

1. The QI Macros provide
A. charts via the ribbon menu.
B. templates of charts and diagrams using the Fill-in-the-Blanks menu.
C. access to statistical tools using the ANOVA and Analysis menu.
D. data transformation tools.
E. all of the above

2. The ideal chart to show performance over time is a
A. control chart.
B. Pareto chart.
C. histogram.
3. The ideal chart for narrowing your focus is a
A. pie chart.
B. Pareto chart.
C. bar chart.
D. control chart.
E. histogram.

4. The optimal way to orient your time-series data in Excel is
A. horizontally across the columns.
B. vertically down the rows.

5. The ideal way to summarize text and other data is to use
A. QI Macros.
B. Excel Pivot Tables and the QI Macros Pivot Table Wizard.
C. a check sheet.

6. After drawing a control chart, you can use the QI Macros menu to
A. add data to the chart.
B. show process changes.
C. analyze stability.
D. delete a point.
E. remove a point from the calculations.
F. all of the above

7. The goal of all charts and data is to
A. eliminate chartjunk.
B. present a clear and compelling business case for improvement.
C. provide a common language for discussing improvement stories.
D. all of the above