An Excel Add-In for Statistical Process Control Charts
Abstract
Statistical process control (SPC) descibes a widely-used set of approaches used to de-
tect 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 op-
erations 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.
Rights
This publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.Collections
Related items
Showing items related by title, author, creator and subject.
-
Optimising Shewhart Charts in Parallel Production Lines
Fricker, R.D. Jr. (2009);I describe a methodology for optimising n Shewhart x-charts operating on parallel production lines in a factory. The goal is to maximise the factory-wide probability of detecting an out-of-control condition subject to ... -
Analog-to-digital conversion techniques for application in digital control systems
Ortega, Manuel, Jr. (Monterey, California. U.S. Naval Postgraduate School, 1967-06);This thesis is primarily concerned with a comparative study of analog-to-digital conversion techniques as currently available. Those discussed and evaluated are of the electromechanical and electronic types including coded ... -
Health Surveillance
Rigdon, Steven E.; Fricker, Ronald D. (2015);This chapter describes the application of statistical methods for health surveillance, including those for health care quality monitoring and those for disease surveillance. The former includes adverse event surveillance ...