# Detailed examples and step by step instructions for creating and analyzing each improvement tool using QI Macros!

#### I find it easier to work from an example, don't you?

Since the QI Macros User Guide only shows you how to use the software, not how to be a Six Sigma wizard, many people have asked for an electronic book of examples that they could turn to for guidance.

This eBook containes examples from healthcare, manufacturing, and service industries to show you how to create and interpret each template or graph, and the associated metrics.

### QI Macros Overview

• Video Tutorials
• Free Online Training Resources
• Creating Charts with QI Macros (Create a Chart Using a Macro/Create a Chart Using a Template)
• Data Formatting Tips

### QI Macros Wizards

• Improvement Project Wizard
• Chart Wizard
• Control Chart Wizard
• PivotTable Wizard
• Statistics Wizard
• Word Count and Word/Number Count Wizard
• Stack/Restack/Unstack

### Control Charts

• Attribute Charts: c, np, p, u
• Variable Charts: XmR, XmR Trend, XbarR, XbarS, XMedianR, I-MR-R
• Control Chart Templates
• Control Chart Dashboards
• Stability Analysis
• Control Chart Rules
• QI Macros Chart Tools Tab to Automate Common Tasks: add data, change rules, etc.

### Charts for Special Circumstances

• CUSUM, EWMA, Moving Average, Hotelling T2, Levey Jennings (Standard Deviation Chart), p' and u' Charts (Prime Charts)

### Capability Charts

• Capability Suite
• Histogram with Cp Cpk, Frequency Histogram, Weibull Histogram
• Capability Templates

### Box, Dot & Scatter Plot

• Box and Whisker, Dot, Matrix, Scatter and Values Plots
• Multivari Chart

### Improvement Charts

• Pareto Chart and Special Features
• Fishbone Diagram
• Countermeasures Matrix

• Run Chart
• Excel Charts

### Statistical Tools

• ANOVA: Single Factor, Two Factor
• Chi-Squared
• F-test
• Regression Analysis
• Equivalence Test
• t-Tests
• Stat Templates

### Fill-in-the-Blank Templates

• Control Chart Templates
• Histogram Templates
• Statistical Templates

### Templates for Lean Six Sigma:

• Lean Tools: Spaghetti Diagrams, Value Stream Maps, Flow Chart, Time Tracking Tool, Time Value Map
• Diagrams: Tree, Arrow, Relationship Diagram
• Calculators: Sample Size, DPMO, RTY
• Improvement Tools: Cause Effect Matrix, Three-Legged, Five Why, Defect Tracking Matrix, Hazard Analysis - Bow Tie Risk Assessment
• DOE, Gage R&R, QFD, FMEA and Control Plan
• Planning and Project Management Tools: Voice of the Customer Matrix and Balanced Scorecard

### Your "Million Dollar Money Belt" Improvement Strategy

QI Macros Six Sigma Tools Example eBook: View Sample Pages