Excel is a popular tool for statistical analysis, especially among non-statisticians. :-) This page lists some of the templates I've created over the years for performing some common tasks related to Lean Six Sigma, quality control, and statistics. You may also want to see my article on Monte Carlo Simulation. - J.W.

Statistics and Quality Control

Quality Control Templates

Control Chart Template Control Chart Template
Create X-bar, R, and S Charts easily using this template.
Pareto Chart Template Pareto Chart Template
Run a pareto analysis without having to create your own chart from scratch.
Fishbone (Cause-and-Effect) Diagram Cause and Effect Diagram
Print a blank fishbone diagram for your brainstorming session, or create a cause and effect diagram using Excel.
PICK Chart (for LSS) PICK Chart Template
This Lean Six Sigma tool helps you assign tasks into categories based on Value and Difficulty.
Gantt Chart Template Gantt Chart Template
This tool is useful for planning and assigning tasks. A useful tool for process improvement meetings and LSS events.


Statistics & Charts

Box Plot Template Box Plot Template
Create box and whisker plots in Excel to compare multiple data sets.

More Statistics, Quality Control, and Six Sigma Tools

  • DMAIC Six Sigma Tools at systems2win.com - Though I've never used any of this company's tools, it is clear that these people have worked in the thick of six sigma.
  • Statistical Functions for Excel by Roger Myerson of the University of Chicago - Dr. Myerson provides two free addins for enhancing the statistical functions and procedures of Excel, as well as an addin for creating tornado diagrams (for sensitivity analysis).


Like This Page?

Become a Fan

Vertex42's Facebook Page Vertex42's Google+ Page Vertex42's Pinterest Page
Excel training for your entire company

Browse Template Categories