Cusum and EWMA Charts for Detecting Small Shifts in Process


© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

Shewart control charts may not be sensitive enough to detect small changes in the process mean. When greater sensitivity is required, consider using the Cusum or EWMA chart.

Cumulative Sum (Cusum Chart)

A Cusum chart plots the cumulative sum of deviations of successive sample means from a target. When running a Cusum Chart in the QI Macros, the macros will prompt you for a target value. The Cusum analyzes variation from that target value looking for cumulative shifts away from the center line.

Here is an example of the same data plotted using an XmR and a Cusum chart. Notice how the Cusum chart more quickly and clearly identifies the process shift.

Cusum Chart

 

XmR Chart

Exponetially Weighted Moving Average (EWMA) Chart

The EWMA Chart plots the moving averages of data and assigns weights that decrease exponentially from the present to the past. As a result, the average values are influenced more by recent data points than older points. When running an EWMA chart in the QI Macros, the macros will prompt you for a weight between 0 and 1. The default value is 0.2.

Here is an example of an EWMA chart and XmR chart plotted using the same data.

EWMA Chart

XmR Chart

Both of these charts can be found on the QI Macros pull down menu under control charts.

To purchase the QI Macros go to https://www.qimacros.com/orderform.html.

If you already own the QI Macros, you can purchase an upgrade at https://www.qimacros.com/orderup.html . You must purchase one upgrade for each license you own.

Buy QI Macros Excel SPC Software for Histograms and Control Charts Now QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H


© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

Hospital Bed Management System

Patient LOS System

Time Tracking Templates

QI Macros 30-day Trial & FREE QI Macros Course
Name:
E-mail
 

QI Macros SPC Software for Excel
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee

The QI Macros for Excel $139, is an inexpensive easy to use set of Excel add-ins for statistical process control and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp, Cpk), scatter and control charts (with stability analysis).

It contains over 70 fill in the blank templates such as the Ishikawa diagram, QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test, and regression analysis.

Buy All-in-One, Excel SPC Software Now

Quantity Discounts

Customer Testimonials

Minitab Comparison

QI Macros FAQs

FREE Lean Six Sigma Course
& QI Macros 30-day Trial
Name:
E-mail