SPC (Statistical Process Control) Excel Template – 3 Factor DOE Folks, as promised from yesterday\’s blog post, here is a 3 factor DOE Excel Template for you to use. Credit must be given to Dean Christolear over at CpkInfo.com, who granted us permission to use the templates. This spreadsheet allows the user to perform a […]

# Category Archives: SPC

## A Simple Analysis of Variance (ANOVA) in Excel

A Simple Analysis of Variance (ANOVA) in Excel One of the most important steps in any Six Sigma project is the ANOVA or Analysis of Variance. ANOVA is found in the Analyze phase of the DMAIC methodology (Define-Measure-Analyze-Improve-Control). ANOVA is used depending on the type of data that is available whether it is attribute or […]

## A Simple Approach to Explaining the Degrees of Freedom

A Simple Approach to Explaining the Degrees of Freedom We, as Statisticians, Six Sigma Belts and Quality Practitioners have utilized the term degrees of freedom as a part of our hypothesis testing, such as the t-Test for Comparison of Two means and ANOVA (ANalysis Of VAriance), and confidence intervals, just to mention a few references. […]

## Statistical Process Control for Dummies

If learning complex math, arithmetic, or statistics isn’t needed then why introduce Statistical Process Control or SPC for short? SPC simply put is a quality control method employing statistical methods. Statistical Process Control is applied in order to monitor and control a process. Monitoring and controlling the process ensures that it operates at its full potential and […]

## Introduction to Equal Variance Assumption

Use of Equal Variance Assumption with ANOVA The equal variance assumption is important in statistics because it applies to two of the most widely used tools, the two-sample t-test, and Analysis of Variance (ANOVA). Both of these tools are used to test whether there are differences in population means, based upon the evidence present in […]

## Introduction to Six Sigma Measurement System Analysis

I thought it was time to break out a little update on Measurement System Analysis (MSA for short) for those of you just learning it. I can fully understand how frustrating this is because MSA is one of the toughest topics for both green belts and black belts in the Six Sigma curriculum. For black belts, […]

## Binomial and Poisson Probability Excel Download

Binomial and Poisson Probability Excel template now available. Be sure to visit more great templates at cpkinfo.net. The Binomial and Poisson spreadsheet allows you to make predictions regarding the number of defective items (or defects) in a sample. This is a very powerful spreadsheet that makes sampling predictions easy. Features Include: Both Binomial and Poisson distributions are supported […]

## Basic Statistics Excel Template Available for Download

Basic Statistics Excel Template Folks , here is the fourth posting of the cpkinfo.com repost (with permission from Dean Christolear, of course). From cpkinfo.com, here is the description of the Basic Statistics Excel Template. This tool is a great start for college or university students studying statistics, or even for advanced high school students with a […]

## Attribute SPC Excel Template Available for Download

For anyone who is looking for a a great Attribute SPC Excel Template look no further. Dean Christolear at CpkInfo.com has many outstanding templates that he gave permission to templatestaff.com to publish. From cpkinfo.com, here is the description of the Attribute SPC Excel Template: This spreadsheet will create one of four attribute spc control charts; […]

## SPC (Statistical Process Control) – Attribute Gage R&R Excel Template

SPC (Statistical Process Control) Excel Template – Attribute Gage R&R Here is the second post in the (SPC) series throughout the month of June. This one features an Attribute Gage R&R This spreadsheet allows the user to perform a complete Attribute Gage Repeatability and Reproducibility (GR&R) study. Attribute gages provide information in a pass/fail format. Ring gages, […]