Time Series Analysis (CUSUM)
Jump to navigation
Jump to search
Description
This article describes a method for preparing a Cumulative Sum (CUSUM) control chart.^{[1]}^{[2]}
Model theory
This section is currently under construction. Please check back later for updates and revisions. 
Excel
The CUSUM control chart may be invoked from the Excel formula bar with the following function calls:
=mdTimeSeries_CUSUM(TimeSeriesData as Range, T as Double, Optional k as Double = 0)
Invoking the function with no arguments will print Help text associated with the model, including a link to this page.
The input parameters and calculation results are defined below in matrix notation, along with an example image showing the selection of the same cells and arrays in the Excel interface:


References
 ↑ NIST/SEMATECH, 2012. eHandbook of Statistical Methods, http://www.itl.nist.gov/div898/handbook/, accessed 24 March 2022.
 ↑ NapierMunn, T.J., 2014. Cunning solutions to process improvement. 12th Mill Operators' Conference, Townsville, Qld, 13 September 2014.