QI Macros How to Articles

• Control Chart Cheat Sheet
• Comparative Control Charts
• BACI Charts - Before After Control Impact
• Control Chart Dashboards
• Control Chart Limit Calculations
• Control Chart Rules Menu
• Control Charts of Time and Date Formatted Data
• Is There A Trend In My Data?
• p chart and u chart format options
• Stability Analysis Rules and How to Change Them
• Cusum and EWMA Charts for Detecting Small Shifts in Process
• Time Between Charts
• Does My Data Need to be Normal First?

• Add Data to Control Charts
• Add Target or Goal Lines to Control Charts
• Add Text to Data Point

---

• Show Process Change on Control Chart
• Remove (Ghost) Point from Control Chart Calculations
• Delete a Point from Control Chart

---

• Automate Stability Analysis When New Data is Added
• Analyze Stability with Control Chart Rules
• Show/Hide 1-2 Sigma Lines
• Show/Hide Rule Numbers
• Recalculate UCL/LCL

---

• Convert Skyline to Wave
• Remember/Apply Chart Format

• Automatically Create Control Charts using Control Chart Templates
• Complete List of Control Chart Templates
• Control Chart Templates for Rolling Data
• Control Chart Templates with Center Line Based on the Median
• Control Chart Templates with Fixed Control Limits
• Short Run Control Chart

Control Chart Menu Functions on Templates

• Add Data to Control Charts
• Remove (Ghost) Point from Control Chart Calculations
• Delete a Point from Control Chart
• Add Text to Data Point
• Show Process Change on Control Chart
• Analyze Stability with Control Chart Rules

• Histogram and Process Capability Analysis Cheat Sheet
• Cp Cpk Template
• Histograms: Changing number of bars and class widths
• Histograms: Common Errors
• Histograms: One-Sided Tolerance
• Stability Analysis vs Capability Analysis
• Relationship between Process Capability and Stability Analysis

• Multiple Pareto Charts
• Pareto Chart Analysis
• Pareto Charts - Common Problems
• Pareto Charts of Text Data
• Pareto Charts vs Mosaic Charts

• Analyzing Data With More Than One Variable
• Applications for QI Macros Templates
• Comparing Data using QI Macros
• Gap Analysis using the Transition Matrix
• Tools for Labs - Levey Jennings Chart and Youden Plot
• Variation Charts

• Design of Experiments DOE
• DOE Two Factors at Three Levels Using ANOVA
• Failure Mode and Effects Analysis FMEA
• Quality Function Deployment QFD House of Quality

• MSA Gage R&R Study Cheat Sheet
• Measurement System Analysis MSA Gage R&R Study
• Type 1 Gage R&R Study
• Attribute Gage R&R Study
• Gage R&R Bias and Linearity
• Gage R&R Destructive Testing
• Measurement Variation - Gage RR
• Gage R&R Example: If My Parts Are So Good, Why is My Gage R&R So Bad?

• Case Study - Choosing the Right Chart to Analyze Your Data
• Data Analysis 101
• Formatting Data Before You Run a Chart
• No One Can Read a Spreadsheet
• What Do I Do With My Data?
• How to Organize Your Data in Excel
• PivotTables for Breakthrough Improvement
• Pivot Tables - Is There an Improvement Project Lurking in Your Data?
• Text Mining in Excel

• Choosing the Right Chart - Case Study
• Choosing the Right Chart - Length of Stay by Doctor
• Counting and Packaging Bolts - Multivari Chart
• Manufacturing Scrap Improvement Story
• Mail House Six Sigma Case Study
• Mail Order Fulfillment Case Study (PDF)
• Analyze Patient Satisfaction Survey Data Using Control Charts
• Quality Magazine Jan 2005 Brain Teaser
• SPC Case Study - Analyzing Different Machines

• Change Default Language
• Customize QI Macros Templates for Your Needs
• Data Format and Selection Tips
• QI Macros FAQs
• QI Macros Tech Support
• QI Macros SPC Software for Mac computers

• Excel Articles
• Lean Six Sigma Articles