QI Macros How to Articles and Excel Tips
QI Macros Lessons for Users
These lessons provide an overview plus links to detailed "how to" articles and videos.
QI Macros Trial Overview
These lessons provide a high level overview with links to videos for those evaluating the QI Macros.
More QI Macros and Excel Articles: Click on each heading for a complete list of topics.
Control Charts
- Choosing the Right Control Chart
- Comparative Control Charts
- Control Chart Dashboards
- Control Chart Limit Calculations
- Control Chart Rules Menu
- 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
Control Chart Templates
Control Chart Menu Functions
- Add Data to Control Charts
- Automate Stability Analysis When New Data is Added
- Add Target or Goal Lines 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
- Show/Hide 1-2 Sigma Lines
Control Chart Menu Functions on Templates
Histograms and Capability Analysis
Miscellaneous Charts and Tools
- Analyzing Data With More Than One Variable
- Applications for QI Macros Templates
- Comparing Data using the QI Macros
- Gap Analysis using the Transition Matrix
- Multiple Pareto Charts
- Pareto Chart Analysis
- Pareto Charts of Text Data
- Pareto Charts vs Mosaic Charts
- Tools for Labs - Levey Jennings Chart and Youden Plot
- Variation Charts
Design for Six Sigma
Measurement System Analysis
Data Analysis
Data Presentation Tips
Statistical Tools
- Anova One Way
- Anova Two Way Without Replication
- Anova Two Way With Replication
- Chi-square Contingency Table
- Chi-square Goodness of Fit
- Correlation
- Covariance
- Descriptive Statistics
- Exponential smoothing
- Fisher Exact Test
- Hypothesis testing
- f-Test two sample for variances
- Levene's Test for non-normal variances
- Moving average
- Multiple Regression Analysis
- Non Parametric Tests
- Normality Test
- Rank and percentile
- Regression Analysis
- Sample Size Calculator
- Test of a Proportion
- Test of Two Proportions
- t-test One Sample
- t-test Two-Sample assuming equal variances
- t-test Two-Sample assuming unequal variances
- t-test Paired Two-Sample for Means
- Tukey Quick Test
- z-test two sample
Excel Functions
- Excel's Autofilter Function
- Excel's Custom Fill Series
- Excel's Conditional Formatting to Create a Hospital Bed Management System
- Excel's Data Validation Functions and Features
- Excel Drawing Toolbar and Select Objects - Excel 2003 vs Excel 2007 & 2010
- Excel's Drawing Toolbar and Chart Formatting Tips - Use Excel to Create an Improvement Story
- Excel Formulas
- Excel's Text to Columns and Concatenate Functions to Separate and Combine Data into cells
- Excel's Tables -Running Charts on Data in Tables
- Excel 2007 Ribbon Interface
- Switch Ribbon Menus (2007-2010 to 2003)
- Merge Worksheets or Workbooks Using VLookup or Offset and Match Functions
- Office and Excel 2007-2010
- Time Tracking with Excel to Reduce Cycle Time such as Patient Length of Stay (LOS)
- Track Defects Using Excel's Data Validation Functions
Case Studies
QI Macros Other Info
Lean Six Sigma Lessons and Articles
