ONE GOOD IDEA
Concerning the CUSUM
A simple way to analyze a cumulative sum chart using Excel
by Vladimir Shper
It is well known that the cumulative sum (CUSUM) technique is one of the most widely used tools in data analysis.1,2 The technique is usually recommended for monitoring the changes in process characteristics because CUSUM charts "are much more effective than Shewhart charts in detecting small and moderate-sized sustained shifts in the parameters of the probability distribution of a quality characteristic."3
Contrasted with simple Shewhart charts in which you visually analyze process stability—seeing whether there are points beyond the control limits—visual analysis of a CUSUM chart is rather tiresome. It requires that you construct a so-called V-mask with arms pointing to the left and a central point, which should be placed on each point of the process as it is plotted.
Due to such inconvenience, most textbooks recommend an algorithmic (or table) method to analyze the process stability while working with CUSUM charts.4 But there’s a simple procedure for anyone to plot a moving V-mask on a CUSUM graph by using traditional Excel software.
Example with Excel
Figure 1 shows a CUSUM chart constructed from data in Donald J. Wheeler’s Advanced Topics in Statistical Process Control.5 All the values of this curve are taken from column E (Online Figure 1). This is a typical graph calculated from the formula Si = Si–1– T + xi, in which T denotes a target of the process. In this example, T = 50.6
Calculate the parameters of V-mask as it’s described in any guide. Again, using data from Advanced Topics in Statistical Process Control: H = 4,876 and K = 1,84,7 in which H is a critical distance of V-mask and K is its slope (Online Figure 2). Now, choose any cell in the column next to column E (for example, E15 in Online Figure 1) and construct two straight lines with the slope K starting at points deviated from the chosen point by H units.
In cell F15, enter the formula: =E15 - $L$30 ($L$30 contains the value of H). In cell G15, enter the formula: =E15 + $L$30. For cells F14 and G14, enter =E15 - $L$30 - $L$29 and =E15 + $L$30 + $L$29, respectively ($L$29 contains the value of K).
For cells F13 and G13, you have: =E15 - $L$30 – 2 * $L$29, =E15 + $L$30 + 2 * $L$29, and so on. As a result, you can obtain something like Figure 4. Here, crimson lines show the mask arms pointing to the left, and yellow lines for those pointing to the right (the values for these lines are shown in columns H and I of Online Figure 1).
To draw a V-mask, it is necessary to copy the set of cells that corresponds to your lines (in this example, cells F11:G15) and place it into a cell of interest. Doing this, you should take into account the length of the V-mask arm or how many cells you used for depicting the sloping lines.
If the regions of two successive drawings overlap, erase the previous one. Otherwise, several extra lines will appear and make the picture a bit ambiguous. A comparison with data in Advanced Topics in Statistical Process Control8 shows that Online Figure 3 leads to the same results as a traditional V-mask.
Apparently, Excel allows you to easily change the parameters of V-mask. Such a simple technique may be useful for quality practitioners, especially when you consider the pervasiveness of the Excel application.
- Donald J. Wheeler, Advanced Topics in Statistical Process Control, SPC Press, 1995.
- Douglas C. Montgomery, Statistical Quality Control, sixth edition, 2009.
- William H. Woodall, "Controversies and Contradictions in Statistical Process Control," Journal of Quality Technology, 2000, Vol. 32, No. 4, pp. 341-350.
- Montgomery, Statistical Quality Control, see reference 2.
- Wheeler, Advanced Topics in Statistical Process Control, see reference 1, chapter 13, Table 13.1.
- Wheeler, Advanced Topics in Statistical Process Control, see reference 1.
- Ibid, p. 293.
- Ibid, chapter 13, Figures 13.3-13.5.
Vladimir Shper is an associate professor at the Moscow Institute of Steel and Alloys in Russia. He holds a doctorate in reliability from the All Russian Electrotechnical Institute in Moscow. Shper is a senior member of ASQ.