Current Volume | Browse | Search | RSSHome | Instructions for Authors | JSS Style Guide | Editorial Board

Authors: Samuel E. Buttrey
Title: [download]
(83043)
An Excel Add-In for Statistical Process Control Charts
Reference: Vol. 30, Issue 13, Jun 2009
Submitted 2007-09-13, Accepted 2009-03-18
Type: Article
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 1950s, 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.

Paper: [download]
(83043)
An Excel Add-In for Statistical Process Control Charts
(application/pdf, 2.2 MB)
Supplements: [download]
(8105)
SPCCharts.1.4.1.xla: Excel add-in for statistical process control charts
(application/zip, 87.9 KB)
[download]
(4525)
v30i13.xls: Excel spreadsheet with examples from the paper
(application/zip, 8.2 KB)
[download]
(3603)
v30i13.zip: VBA source code
(application/zip, 13.4 KB)
Resources: BibTeX | OAI
Creative Commons License
This work is licensed under the licenses
Paper: Creative Commons Attribution 3.0 Unported License
Code: GNU General Public License (at least one of version 2 or version 3)
Current Volume | Browse | Search | RSSHome | Instructions for Authors | JSS Style Guide | Editorial Board