An Excel Add-In for Statistical Process Control Charts

Samuel E. Buttrey

Journal of Statistical Software, 2009, vol. 030, issue i13

Abstract: Statistical process control (SPC) descibes a widely-used set of approaches used to detect shifts in processes in, for example, manufacturing. Among these are "control charts". Control charts and other SPC techniques have been in use since at least the'50s, and, because they are comparatively unsophisticated, are often used by management or operations personnel without formal statistical training. These personnel will often have experience with the popular spreadsheet program Excel, but may have less training on a mainstream statistical package. Base Excel does not provide the ability to draw control charts directly, although add-ins for that purpose are available for purchase. We present a free add-in for Excel that draws the most common sorts of control charts. It follows the development of the textbook of Montgomery (2005), so it may be well-suited for instructional purposes.

Date: 2009-06-30
References: View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
https://www.jstatsoft.org/index.php/jss/article/view/v030i13/v30i13.pdf
https://www.jstatsoft.org/index.php/jss/article/do ... Charts.1.4.1.xla.zip
https://www.jstatsoft.org/index.php/jss/article/do ... 30i13/v30i13.xls.zip
https://www.jstatsoft.org/index.php/jss/article/do ... e/v030i13/v30i13.zip

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:jss:jstsof:v:030:i13

DOI: 10.18637/jss.v030.i13

Access Statistics for this article

Journal of Statistical Software is currently edited by Bettina Grün, Edzer Pebesma and Achim Zeileis

More articles in Journal of Statistical Software from Foundation for Open Access Statistics
Bibliographic data for series maintained by Christopher F. Baum ().