Learn More About SPC for Excel
To make searching the newsletters easier, we have grouped the newsletters into the categories below. We hope you find the information useful. Select the "Subscribe" button to the right to sign up for our monthly publications.
- Variation
- Dr. W. Edwards Deming
- Control Charts
- Bar Charts: Paretos and Histograms
- Measurement Systems Analysis
- Process Capability
- Root Cause Analysis
- Comparing Processes
- Experimental Design Techniques
- Basic Statistics
- Process Improvement
- Miscellaneous
Variation
- Variation (January 2004)
- Leadership and Variation (February 2004)
- Revisiting Variation (March 2006)
- Overcontrolling a Process: The Funnel Experiment (July 2006)
- Another Look at Variation (January 2008)
The Red Beads: Understanding Variation (February 2009)- Teaching Variation to Leadership (December 2010)
- Returning to the Basics: Variation (January 2012)
- Variation, People and Pay for Performance (March 2012)
- It is the Operator's Fault! (November 2014)
- Horse Racing and Listening to Control Charts (August 2015)
- A Look Back at Variation (December 2016)
- Control Charts and Goals (February 2018)
- Control Limits and Specifications: The Four Process States (February 2022)
Dr. W. Edwards Deming
Dr. Deming and Profound Knowledge - Part 1 (October 2006)- Dr. Deming and Profound Knowledge - Part 2 (November 2006)
- Dr. Deming and Profound Knowledge - Part 3 (December 2006)
- Dr. Deming and Profound Knowledge - Part 4 (January 2007)
- Remembering Dr. W. Edwards Deming (December 2018)
Control Charts - Basics
- Interpreting Control Charts (April 2004)
- Control Strategies (August 2004)
- Use of Control Charts (January 2005)
- The Impact of Statistical Control (February 2006)
- Selecting the Right Control Chart (April 2006)
- Control Limits - Where Do They Come From? (September 2010)
The Purpose of Control Charts (March 2011)- When to Calculate, Lock, and Recalculate Control Limits (August 2011)
- My Process is Out of Control! Now What Do I Do? (June 2012)
- The Estimated Standard Deviation and Control Charts (November 2012)
- Control Chart Rules and Interpretation (March 2016)
- How Much Data Do I Need to Calculate Control Limits (August 2016)
- Applying the Out of Control Tests (January 2017)
- Control Charts and the Central Limit Theorem (May 2017)
- Three Sigma Limits and Control Charts (July 2017)
- Control Charts, ANOVA and Variation (December 2017)
- The Difficulty of Setting Baseline Data for Control Charts (November 2017)
- How to Mess Up Control Charts (August 2019)
- The Problem of In Control but Out of Specifications (February 2020)
- Control Charts and Adjusting a Process (May 2021)
- The Average Run Length and Detecting Process Shifts (July 2021)
- Which Out of Control Tests Should I Use? (November 2022)
- The Impact of Out of Control Points on Baseline Control Limits (February 2023)
Variable Control Charts
- Xbar-R Charts - Part 1 (March 2005)
- Xbar-R Charts - Part 2 (April 2005)
- Individuals Control Charts (October 2006)
- Chunky Data and Control Charts (April 2007)
- Rare Events and X-mR Charts (May 2007)
Xbar-s Control Charts - Part 1 (September 2008)- Xbar-s Control Charts - Part 2 (October 2008)
- Xbar-mR-R (Between/Within) Control Chart (January 2011)
- Control Charts and Non-Normal Data (June 2014)
- Keeping the Process on Target: CUSUM Charts (August 2014)
- Keeping the Process on Target: EWMA Charts (September 2014)
- Comparing Individuals Charts to Attribute Charts (April 2015)
- z-mR Control Charts for Short Production Runs (July 2015)
- Multivariate Control Charts: The Hotelling T2 Control Chart (October 2019)
- Medians and the Individuals Control Chart (October 2020)
- Comparing XBar-R and XBar-s Control Charts (April 2021)
- Comparing X-mR and Xbar-R Control Charts (August 2021)
- Ten Things to Know When Using the Individuals Control Charts (March 2022)
Rational Subgrouping
Rational Subgrouping and Xbar-R Charts (May 2005)- Rational Subgrouping and Xbar-R Charts - Part 2 (June 2005)
- SPC, Rational Subgrouping, and Golf (January 2013)
- SPC and Rational Subgrouping (February 2013)
Attribute Control Charts
- c Control Charts (July 2004)
p Control Charts (July 2005) - u Control Charts (July 2007)
- Small Sample Case for p and np Control Charts (February 2008)
- Small Sample Case for c and u Control Charts (March 2008)
- np Control Charts (March 2009)
- Attribute Control Charts Overview (April 2009)
- g Control Chart (February 2011)
- Laney p' Control Chart (May 2019)
- Laney u' Control Chart (September 2020)
- The g Chart vs the Individuals Chart (October 2021)
Control Chart Examples
- Monitoring Customer Complaints Using SPC (June 2006)
- SPC and On-Time Performance (June 2007)
- SPC & Process Improvement in the Warehouse (August 2007)
SPC and Customer Service (November 2008) - An Example of the Misuse of SPC in Health Care (August 2009)
- SPC and Pharmaceutical In-Process Control (September 2009)
- SPC and Pharmaceutical Finished Product Quality Specifications (October 2009)
- KPIs, Control Charts and Linking of Measurements (July 2011)
- Control Charts and America's Favorite Pastime - Baseball (November 2011)
- SPC, Downtime, and Overall Equipment Effectiveness (December 2011)
- Control Charts and Surveys (April 2012)
- Control Charts and Purchasing (May 2012)
- Making Sense of Data: SPC and Aviation (April 2013)
SPC and Your Suppliers (July 2013)- Control Charts and Website Data (August 2013)
- My Blood Pressure is What??? (March 2015)
- SPC and Selecting a Supplier (October 2015)
- SPC and Global Warming (December 2015)
- Trend Control Charts and Global Warming (January 2016)
- SPC and Global Warming Update (February 2017)
- Attribute Control Charts in Health Care (April 2017)
- SPC and Global Warming - 2017 Update (March 2018)
- Baseball Has Changed – The Demise of the Complete Game and Other Tidbits (August 2018)
- COVID-19 Data and Variation (April 2020)
COVID-19 Data: Does a Control Chart Add Anything to the Analysis? (May 2020)- Global Warming: A Trend or Step Changes? (June 2020)
- SPC and Global Warming: 1880-2020 (January 2021)
- Plotting the Data and Immigration (March 2021)
- Dashboards, KPIs and Noise (June 2021)
- Is Overall Equipment Effectiveness (OEE) an Effective Metric? (September 2021)
- SPC and Global Warming: 1880 - 2021 (January 2022)
- SPC and Global Warming: 1880 – 2022 (January 2023)
- Control Charts and Tornadoes (April 2023)
Bar Charts: Pareto and Histograms
Pareto Diagrams (June 2004, updated June 2018)- Histograms - Part 1 (December 2005)
- Histograms - Part 2 (January 2006)
- Using Pareto Diagrams and Control Charts Together (November 2010)
- Variable and Two-Level Pareto Diagrams (January 2020)
- The Impact of Bar Width on Histograms (October 2022)
- Variation and Histograms (March 2023)
Measurement Systems Analysis/Gage R&R
Operational Definitions/Measurements Systems Analysis (March 2004)- Monitoring Test Methods Using SPC (May 2006)
- Variables Measurement Systems - Part 1: Stability (September 2007)
- Variables Measurement Systems - Part 2: Bias (October 2007)
- Variables Measurement Systems - Part 3: Linearity (November 2007)
- Variables Measurement Systems - Part 4: Gage R&R (December 2007)
- Measurement Systems - Is Yours Any Good (November 2009)
- Attribute Gage R&R Studies: Comparing Appraisers (May 2010)
- Attribute Gage R&R Studies: Part 2 (June 2010)
- Levey-Jennings Charts (August 2010)
- ANOVA Gage R&R - Part 1 (August 2012)
- ANOVA Gage R&R - Part 2 (September 2012)
- ANOVA Gage R&R - Part 3 (October 2012)
- Gage R&R for Non-Destructive and Destructive Test Methods (September 2013)
- Destructive Gage R&R Analysis (October 2013)
- Evaluating the Measurement Process - Part 1 (December 2014)
- Evaluating the Measurement Process - Part 2 (January 2015)
- Three Methods to Analyze Gage R&R Studies (February 2015)
Monitoring Destructive Test Methods (November 2015)- Probable Error and Your Measurement System (April 2016)
- Specifications and Measurement Error (May 2016)
- SPC and the Lab (November 2017)
- The Impact of Measurement Error on Control Charts (January 2018)
- Acceptance Criteria for Measurement Systems Analysis (April 2018)
- Operational Definition of a Consistent Measurement System (May 2018)
- The Short EMP Study (June 2019)
- Evaluating the Measurement Process (EMP) Overview (July 2019)
- Five Common Mistakes with Gage R&R Studies (November 2019)
- Operator-Part Interactions in Gage R&R Studies (December 2019)
- A Tale of Two Precision to Tolerance Ratios (March 2020)
- How Does Measurement Variation Impact Control Chart Signals? (November 2020)
- The Calculations Behind a Gage Linearity Study (February 2021)
- Individuals Control Charts and Levey-Jennings Charts (December 2021)
- How to Monitor Measurement Systems Over Time (May 2023)
Process Capability
Process Capability - Part 1 (October 2004)- Process Capability - Part 2 (November 2004)
- Process Capability - Part 3 (December 2004)
- Cpk Improvement Methodology (February 2012)
- An Interactive Look at Process Capability (March 2014)
- Cpk Alone is Not Sufficient (April 2014)
- Cpk vs Ppk: Who Wins (May 2014)
- Process Capability and Non-Normal Data (July 2014)
- Binomial Process Capability (July 2020)
- Poisson Process Capability (August 2020)
- What Do the Process Capability/Performance Metrics Measure? (December 2020)
- Process Capability and Variation (April 2022)
Root Cause Analysis
- Scatter Diagrams (February 2005, updated July 2018)
- Creating Cause and Effect Diagrams (October 2005)
Analyzing Cause and Effect Diagrams (November 2005)- Failure Mode and Effects Analysis (May 2008)
- Linear Regression - Part 1 (June 2008)
- Linear Regression - Part 2 (July 2008)
- Single Factor ANOVA (December 2008)
- Waterfall Charts (July 2010)
- Correlation Analysis (April 2011)
- Scatter Plot Matrix (May 2011)
- Stepwise Regression (September 2015)
- Analysis of Variance (ANOVA) and the Variability Chart (May 2022)
- Understanding Regression Statistics – Part 1 (August 2022)
- Understanding Regression Statistics – Part 2 (September 2022)
Comparing Processes
- Comparing Two Processes (August 2006)
- Paired Sample Comparison (September 2006)
Comparing Multiple Processes (February 2007) - Box and Whisker Plots (March 2007)
- Comparing Multiple Processes: Bonferroni's Method (January 2009)
- Bartlett's Test for Equality of Variances (July 2009)
- The Analysis of Means and Ranges (January 2019)
- The Analysis of Mean Moving Ranges - ANOMmR (September 2019)
- Modified Levene's Test for Equality of Variances (November 2021)
Experimental Design Techniques
- Experimental Design Techniques - Part 1 (January 2010)
- Experimental Design Techniques - Part 2 (February 2010)
- Experimental Design Techniques - Part 3 (March 2010)
- Design of Experiments in Pharmaceutical Development (April 2010)
- Fractional Factorial Designs - Part 1 (September 2018)
- Fractional Factorial Designs - Part 2 (October 2018)
Basic Statistics
- Explaining Standard Deviation (August 2005)
- Inspecting Supplier Material (September 2005)
- Are the Skewness and Kurtosis Useful Statistics (April 2008)
- Normal Distribution (May 2009)
- Normal Probability Plots (June 2009)
Polls, Sample Size and Error Margin (October 2010)- Anderson-Darling Test for Normality (June 2011)
- Hypothesis Testing (May 2015)
- How Many Samples Do I Need? (June 2015)
- Are the Skewness and Kurtosis Useful Statistics (Revisited - February 2016)
- What? My Data are Not Normal? (June 2016)
- Box-Cox Transformation (July 2016)
- Distribution Fitting (September 2016)
- Deciding Which Distribution Fits Your Data Best (October 2016)
- Just Because There is a Correlation, Doesn't Mean .. (November 2016)
- Interpretation of Alpha and p-Value (March 2017)
- Descriptive Statistics (June 2017)
- Nonparametric Techniques for a Single Sample (February 2019)
- Nonparametric Techniques for Comparing Processes (March 2019)
- Analysis of Individual Values - ANOX (April 2019)
- Item Analysis (December 2022)
Process Improvement
- Problem Solving Model (May 2004)
- Data Collection (September 2004)
Process Management Model (November 2006)- Balancing People and Process (October 2011)
- But, You Can't Measure What I Do! (September 2011)
- Kaizen and SPC (March 2013)
- Just Plot the Data - It is So Simple! (May 2013)
- When an Average Isn't the Average (June 2013)
- Process Analysis (November 2013)
- Affinity Diagrams (January 2014)
- The Theory of Constraints (February 2014)
- Problem Solving Tools and M&M's (October 2014)
- Dr. Ishikawa’s Seven Quality Tools (August 2017)
- Time and Muda (September 2017)
- Process Flow Diagrams (October 2017)
- What Do I Work on First: Process or Measurement? (June 2022)
Miscellaneous Topics
Top Ten SPC Questions (December 2013)
SPC Knowledge Base
Sign up for our FREE monthly publication featuring SPC techniques and other statistical topics.
Customer Stories
Click here to see what our customers say about SPC for Excel!
SPC Around the World
SPC for Excel is used in 80 countries internationally. Click here for a list of those countries.