An Excel Add-In for Statistical Process Control Charts
t 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 stati...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Foundation for Open Access Statistics
2009-06-01
|
| Series: | Journal of Statistical Software |
| Subjects: | |
| Online Access: | http://www.jstatsoft.org/v30/i13/paper |
| _version_ | 1818364494802321408 |
|---|---|
| author | Samuel E. Buttrey |
| author_facet | Samuel E. Buttrey |
| author_sort | Samuel E. Buttrey |
| collection | DOAJ |
| description | t 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 haveexperience with the popular spreadsheet program Excel, but may have less training on amainstream statistical package. Base Excel does not provide the ability to draw controlcharts 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. |
| first_indexed | 2024-12-13T22:05:16Z |
| format | Article |
| id | doaj.art-46eb4caa9823477988c55377d3d0fbc4 |
| institution | Directory Open Access Journal |
| issn | 1548-7660 |
| language | English |
| last_indexed | 2024-12-13T22:05:16Z |
| publishDate | 2009-06-01 |
| publisher | Foundation for Open Access Statistics |
| record_format | Article |
| series | Journal of Statistical Software |
| spelling | doaj.art-46eb4caa9823477988c55377d3d0fbc42022-12-21T23:29:51ZengFoundation for Open Access StatisticsJournal of Statistical Software1548-76602009-06-013013An Excel Add-In for Statistical Process Control ChartsSamuel E. Buttreyt 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 haveexperience with the popular spreadsheet program Excel, but may have less training on amainstream statistical package. Base Excel does not provide the ability to draw controlcharts 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.http://www.jstatsoft.org/v30/i13/paperstatistical process controlSPCcontrol chartsExcel |
| spellingShingle | Samuel E. Buttrey An Excel Add-In for Statistical Process Control Charts Journal of Statistical Software statistical process control SPC control charts Excel |
| title | An Excel Add-In for Statistical Process Control Charts |
| title_full | An Excel Add-In for Statistical Process Control Charts |
| title_fullStr | An Excel Add-In for Statistical Process Control Charts |
| title_full_unstemmed | An Excel Add-In for Statistical Process Control Charts |
| title_short | An Excel Add-In for Statistical Process Control Charts |
| title_sort | excel add in for statistical process control charts |
| topic | statistical process control SPC control charts Excel |
| url | http://www.jstatsoft.org/v30/i13/paper |
| work_keys_str_mv | AT samuelebuttrey anexceladdinforstatisticalprocesscontrolcharts AT samuelebuttrey exceladdinforstatisticalprocesscontrolcharts |