PPM / Sigma Level Calculator

Template/Calculator 
 
Excel 
 


Excel file containing templates for basic quality improvement calculations including:
 PPMDPM 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
 DPMPPM Table
Useful Statistics Functions in Excel


Listing of commonly used statistical functions in Excel.
This document contains a brief overview of basic statistics and core terminology/concepts used in data analysis/problemsolving. 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


A review of rules for reporting significant digits.
Includes probability tables and examples including:
 Normal
 Binomial
 Poisson
 Gamma
Normal Probability Tables


This file contains probability tables for the normal distribution.
Lean Six Sigma References


This document contains a list of reference material to learn more about Lean Six Sigma analysis, application and methodologies.
This template provides a framework for communicating results of Design for Six Sigma (DFSS) analysis and results in presentation format.
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


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