Free Resources


QETools Quick Links…

QETools Tutorial

Reference | PDF |

This tutorial serves as an introduction to QETools including:

  • Getting Started with QETools
  • Overview of Many of the Various QETools Tools and Templates

QETools Sample Data File

Data File | Excel |

This data file is used as the sample data set for both the PDF and Video tutorials.


Other Resources…

PPM / Sigma Level Calculator

Template/Calculator | Excel |

Excel file containing templates for basic quality improvement calculations including:

  • PPM-DPM Calculator
  • Sigma Level Converter
  • Allowable Mean Deviation (given Cp and Cpk compute allowable mean in terms of sigma)
  • Process Capability Converter
  • Cp Confidence Interval
  • Mean Confidence Interval
  • Variance Confidence Interval
  • DPM-PPM Table

Useful Statistics Functions in Excel

Reference | Word |

Listing of commonly used statistical functions in Excel.

Statistics Review

Reference | PDF |

This document contains a brief overview of basic statistics and core terminology/concepts used in data analysis/problem-solving.  Topic covered are:

  • Qualitative and Quantitative Data
  • Descriptive Statistics
    • Sample data versus population data
    • Parameters and statistics
    • Location statistics (measures of central tendency)
    • Dispersion statistics (measures of variability)
  • Frequency Distributions
    • Frequency measures
    • Histogram
    • Discrete histogram example
    • Continuous data histogram
  • Normal Distribution
    • Properties of the normal distribution
    • Estimating probabilities using normal distribution
  • Linear Regression Analysis
    • General regression equation
    • Simple linear regression
    • Correlation, R
    • Using scatter plots to show linear relationships

Rules on Significant Digits

Reference | Word |

A review of rules for reporting significant digits.

Probability Tables

Reference | Excel |

Includes probability tables and examples including:

  • Normal
  • Binomial
  • Poisson
  • Gamma

Normal Probability Tables

Reference | PDF |

This file contains probability tables for the normal distribution.

Lean Six Sigma References

Reference | PDF |

This document contains a list of reference material to learn more about Lean Six Sigma analysis, application and methodologies.

DMAIC Case Template

Template | PowerPoint |

This template provides a framework for communicating results of Design for Six Sigma (DFSS) analysis and results in presentation format.

Dimensions and Units

Reference | Units |

This file contains a quick review of basic SI units, derived units as well as standard SI prefixes (e.g., kilo, milli, tera, etc.).

Design for Six Sigma (DFSS) Report Template

Template | Word |

Use this template for preparing a Design for Six Sigma (DFSS) written certification project.