Detailed examples and step by step instructions for creating and analyzing each Six Sigma & SPC 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 a book of examples that they could turn to for guidance.

This 94 page tool book 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 example book

Table of Contents Highlights:

QI Macros Overview

  • The QI Macros Menu
  • 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

  • Data Mining Wizard
  • Chart Wizard
  • Control Chart Wizard
  • PivotTable Wizard
  • Statistics Wizard
  • Word Count and Word/Number Count Wizard
  • Paste Link/Paste Link Transpose
  • 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 Whisker, Dot, Matrix, Scatter and Values Plots
  • Multivari Chart
  • Tornado Chart

Improvement Charts

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

Other Charts

  • 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 Book View Sample Pages

QI Macros Example eBook (#W239) Download Only; Nothing Shipped