Page 155 - Lean six sigma demystified

134 Lean Six Sigma DemystifieD

tools on or ask you to install them using your Office or Excel CDs. To check
if they have been installed, click on Tools-Data Analysis. If you cannot see Data
Analysis in the Tools menu, the statistical analysis tools are not installed.
1. Select the data to analyze. This data must be organized in columns.
2. From the QI Macros menu, select ANOVA and Other Analysis Tools.

3. Click on the appropriate analysis tool (ANOVA, regression, F-test,
t-test, etc.).

See sample test data for each tool and test on your computer at c:\qimacros\
testdata.

Power Tools for Lean Six Sigma

As you can see from these examples, Excel and the QI Macros are power tools
to simplify Lean Six Sigma. By putting your data into Excel, summarizing it
with pivot tables, and graphing it with the QI Macros, you can automate and
accelerate your journey toward Six Sigma.

1. The QI Macros give you the power to select data and immediately
draw all of the key charts and diagrams: line, run, and Pareto charts for
problem solving as well as histograms and control charts for reducing
variation.
2. The QI Macros templates give you Fill-in-the-Blanks simplicity for control
charts, Pareto charts, fish bones, flowcharts, and value stream mapping.
3. The QI Macros Data Transformation tools give you the ability to stack and
restack your data and use pivot tables.

4. The QI Macros ANOVA and Analysis tools give you simplified access to
Excel’s statistical tools and much more.

Start using Excel and the QI Macros to organize, analyze, and graph your
data to illuminate the opportunities for improvement.

Analyzing Customer Service Data Hidden in

Trouble-Reporting Systems

In service industries, much of the information you need to make break-
through improvements is buried in trouble-reporting systems. Help and