An Excel Add-In for Statistical Process Control Charts
Buttrey, Samuel E.
MetadataShow full item record
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.
RightsThis 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.
Showing items related by title, author, creator and subject.
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 ...
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 ...
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 ...