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.
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
- Improvement Project 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 and 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 eBook: View Sample Pages