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
|
|
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/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
|
|
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. |