Excel Macros for Lean Six Sigma, SPC and ISO

You get all these Charts

QI Macros Wizards

• Chart Wizard: Selects various charts based on your data.
• Control Chart Wizard: Selects the correct control chart based on your data.
• PivotTable Wizard: Summarizes your data.
• Statistics Wizard: Automates hypothesis testing.

Control Charts with Stability Analysis

• c chart
• np chart
• p chart
• q chart
• u chart
• g chart
• t chart
• p prime chart
• u prime chart
• Analysis of Means chart
• Cusum Chart
• Levey Jennings chart
• Moving Average chart
• EWMA chart
• Individual Moving Range XmR chart
• X bar R chart
• X Median R chart
• X bar S chart
• Control Chart Wizard

Histograms with Capability Analysis - Cp, Cpk
Frequency Histogram - Cp Cpk

Dot Plots

Multivariate Analysis

• Scatter Plot
• Scatter Plot Matrix
• Hotelling T2

Other Charts

Run Chart - average and median
Pareto Chart
Line Graph
Bar Chart
Pie Chart

Includes QI Macros Help File for each chart and tool

• Action Plan
• Affinity Diagram
• APQP tools for AIAG ISO/TS 16949: Control Plan, PFMEA, DFMEA
• Arrow Diagram
• Balanced Scorecard (Tree)
• Block Diagram
• Checksheet
• Control Plans for ISO/TS 16949 APQP
• Control Charts for SPC requirements (e.g., ISO/TS 16949)
  1. Attribute:
     c chart template, np chart template, p chart template, u chart template
  2. Variable:
     Cusum, EWMA, Levey Jennings, Moving Average, Individual Moving Range (XmR) , X ba rR, X bar S and X Median R charts with histogram and normal probability plot (also includes short run templates).
  3. Other Control Charts
     g chart template, q chart ,and t chart template
  4. Histogram
• Cost of Quality
• Countermeasures
• Cp, Cpk Template
• Design of Experiments (Plackett-Burnham 2-3-4 Factor and Taguchi 4-8-16)
• DPMO Six Sigma Calculator
• Failure Prevention Analysis Template
• Fault Tree
• Ishikawa Fishbone Diagram
• Flowchart
• Force Field Analysis
• FMEA , DFMEA and PFMEA for APQP
• Gage R&R Study with range method, anova method, bias, linearity, and Attribute Gage R&R Study
• Gantt Chart
• MSA - Measurement Systems Analysis using Gage R&R
• Non-Parametric Testing
• PFMEA
• PPAP Templates for AIAG ISO/TS 16949
• PDPC Chart
• Pre Control Chart
• Pugh Concept Selection Matrix
• QFD House of Quality
• Relationship/Systems Diagram
• ROC Curve
• ROI Analysis
• Run Chart
• SIPOC Diagram
• Speedometer Chart
• Targets and Means
• Time Tracking
• Tornado Chart
• Transition Planning
• Tree Diagram
• Value-Added Analysis
• Value Stream Map
• Voice of the Customer
• Youden Plot
  

• Control Chart Dashboards for XmR, n, p, c and u charts

• 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
• Moving average
• Multiple Regression Analysis
• NonParametric Tests Including:
  • 1-sample sign test
  • Friedman test
  • Kolmogorov-Smirnov (K-S)
  • Kruskal-Wallis test
  • Mann-Whitney test
  • Mood's Median
  • Sign Test
  • Spearman test
  • Tukey Quick Test
  • Wilcoxon Signed Rank Test
  • Wilcoxon Rank Sum Test
• Normality Test
• Proportions Hypothesis testing
  • Test of a Proportion
  • Test of Two Proportions
• Rank and percentile
• Regression Analysis
• Sample Size Calculator
• 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 for Means

• Box Cox Transformation
• Stack and Restack tables
• Unstack Columns by Label and Subgroup
• Paste Link
• Paste Link Transpose
• Crosstab - PivotTable Wizard 1 to 4 columns
• Count Words in selection