Quality Improvement Tools in Excel

Chart and Statistics Wizards

• Chart Wizard
• Control Chart Wizard
• PivotTable Wizard
• Statistics Wizard

Planning Tools

• Action Plan
• 30-60-90 Day Action Plan
• Affinity Diagram
• Arrow Diagram
• Balanced Scorecard (Tree)
• Blue Ocean Strategy
• Check List | AIAIG Checklist
• Checksheet
• Convert PPM to Cp-Cpk
• DPMO Six Sigma Calculator
• EOQ Calculator
• Gantt Chart
• Hoshin Kanri
• L, T, X Shaped Matrix
• Mind Mapping
• PEST
• Project Charter
• RACI
• Rolled Throughput Yield Calculator
• ROI Calculator
• SIPOC
• Stakeholder Analysis
• SWOT
• Targets and Means Matrix
• Transition Planning
• Tree Diagram
• Voice of the Customer

Improvement Tools

• 8D Report (Ford)
• A3 Report (Toyota)
• Action Plan
• Block Diagram
• Costs of Poor Quality ("Calculators" drop-down)
• Cost of Quality
• Countermeasures
• Defect Tracking Template
• Fault Tree
• Flow Chart
• Force Field Analysis
• Hazard Analysis - Bow Tie
• Ishikawa Fishbone Diagram
• Measurement Matrix
• Non-Parametric Tests
• Pareto Chart
• PDPC Chart
• Test of Proportion
• QI Story
• Relationship/Systems Diagram
• Risk Assessment Matrix
• Time Tracking
• Tree Diagram
• TRIZ Template
• Turtle Diagram

Flow Charts and Fishbones

• Block Diagram
• Fault Tree
• Flow Chart
• Ishikawa Fishbone Diagram
• Spaghetti Diagram
• Tree Diagram
• Value Stream Map

SPC Control Charts

Attribute Control Charts

• c Chart Template
• np Chart Template
• p Chart Template
• u Chart Template
• g Chart Template
• c, p, u, np Dashboard

Variable Control Charts

• XmR Dashboard
• XmR Four Pak
• XmR + USL, LSL, Target
• XmR 30000-foot
• XmR Autocorrelated
• X bar R
• X bar S
• X Median R

Options within most control chart templates:

• Center Line Based on Average
• Center Line Based on Median
• Templates to Handle Rolling Data
• Control Chart with Fixed or Historical Control Limits

SPC Charts Other Control Charts

• Cusum
• EWMA
• Hotelling T2 Individuals
• Levey Jennings QC Chart
• M Chart
• Moving Average
• PreControl Chart
• q Chart Template
• t Chart Template

AIAG and ISO

• APQP Checklists
• Control Plans
• Failure Prevention Analysis Template
• FMEA, DFMEA and PFMEA
• Gage R&R with range method, anova method, bias, linearity, attribute Gage R&R study and Gage R&R Type 1.
• PPAP Forms - AIAG 4th Ed
• Pre Control Chart
• Uncertainty ISO 17025

DFSS, DOE, MSA

• Design of Experiments (Plackett-Burnham 2-3-4 Factor and Taguchi 4-8-16)
• FMEA, DFMEA and PFMEA
• Gage R&R range method, anova method, bias, linearity, and attribute
• Pugh Concept Selection Matrix
• QFD House of Quality

Lean Tools

• Lean Scorecard
• Lean Takt Time and NVA
• MODAPTS Template
• Time Tracking Tool
• Value-Added Flow Analysis
• Value Stream Map
• Yamazumi Chart

Project Management Tools

• Action Plan
• Affinity Diagram
• Arrow Diagram
• Check List | AIAIG Checklist
• Checksheet
• Cost of Poor Quality Matrix
• Cost of Quality
• Driver Diagram
• Driver Matrix
• Earned Value Management Formulas
• Fishbone Diagram or Ishikawa Diagram
• Flow Chart
• Gantt Chart
• Measurement Matrix
• Resource Matrix
• ROI Calculator
• SIPOC
• Stakeholder Analysis
• Time Tracking Tool
• Tree Diagram
• Voice of the Customer
• Work Breakdown Structure

Other Charts

• Box and Whisker Plot
• Cp, Cpk Template
• Delta Chart
• Histogram
• Kaplan-Meier Step Plot
• Pareto Chart
• Probability Plot
• ROC Curve
• Run Chart
• Scatter Plot Diagram
• Speedometer Chart
• Stem and Leaf Plot
• Target and Line Chart
• Tornado Chart
• Youden Plot

Statistical Analysis

Data Normality

• Normal Probability Plot
• Anderson Darling Test

Hypothesis Tests

• Null vs. Alternate Hypothesis
• Type i and ii Risk
• p Values

Test of Means

• One Way ANOVA
• One Way ANOVA Post Hoc
• Two Way ANOVA Without Replication
• Two Way ANOVA With Replication
• Two Way ANOVA Nested with Replication
• ANCOVA
• MANOVA
• One Sample t Test
• Paired t Test - Two Sample for Means
• Two Sample t Test (Equal and Unequal Variances)
• z-test Two Sample for Means
• Equivalence Test
• Two One Sided Test for Equivalence (TOST)

Test of Variances

• f-test Two Sample
• Levenes Test

Test of Proportions

• Test of a Proportion
• Test of Two Proportions

Test Relationship

• Autocorrelation
• Chi-square Contingency Table
• Chi-square Goodness of Fit
• Correlation
• Covariance
• Descriptive Statistics
• Fisher Exact Test
• Regression Analysis
• Multiple Regression Analysis
• Logistic Regression (Binary)
• Adjusted R Squared
• Box Cox Transformation

Non-Parametric Tests

• 1-sample sign test
• Friedman test
• Kolmogorov-Smirnov test
• Kruskal-Wallis test
• Mann-Whitney test
• Mood's Median test
• Sign test
• Spearman test
• Tukey Quick test
• Wilcoxon Rank Sum test
• Wilcoxon Signed Rank test

Sampling

• AQL Sampling Tables
• Sample Size Calculator