Cusum Chart in Excel

Cumulative Sum Charts Can Detect Small Shifts in a Process

Cusum charts can detect process shifts more rapidly than the XmR or XbarR. If a trend develops, it's evidence that the process has shifted.

A Cusum Chart consists of:

  • A target which is either provided by you or calculated as the mean of your data.
  • Upper Cusum Limit and Lower Cusum Limit lines.
  • C+ and C- lines which represent the cumulative sum of deviations of successive sample means from a target. Use these lines to determine if your process is shifting.

Default values calculated in the Cusum Chart:

k (slack) = 1/2 of your StDev
FIR = 0
h = 4

Example of a Cusum Chart Created by QI Macros Add-in for Excel

cusum chart in excel

Compare a Cusum Chart with an EWMA Chart

Cusum Chart

cusum chart compared to ewma chart

EWMA Chart

ewma chart excel

Compare a Cusum Chart with an Individual Moving Range Chart

Cusum Chart

cusum chart compared to individuals chart

Individual Moving Range Chart

individuals chart in excel

Notice how the Cusum chart more quickly and clearly identifies the process shift.

Learn More...

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $299 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free
Data Mining and Analysis
Download Free QI Macros Trial
Buy QI Macros for Excel Now