amanbhai
2nd June 2006, 06:17 AM
HOw do we calculate the control chart by using excel? I search it & could not find any. Positively
|
*Please be aware that SOME RECENT forum threads may not yet be indexed by Google. |
|
View Full Version : How do we calculate the control chart by using excel .xls spreadsheet? apestate 2nd June 2006, 06:46 AM I assume you're asking how to establish UCL and LCL, upper control limit and lower control limit. These are usually established through a capability study. Direct answer: http://www.qualitydigest.com/oct97/html/excel.html Background info: http://www.isixsigma.com/library/content/c030306a.asp Good search to try: http://www.google.com/search?hl=en&lr=&q=ucl+lcl+SPC+excel+formula+example Steve Prevette 2nd June 2006, 01:56 PM HOw do we calculate the control chart by using excel? I search it & could not find any. Positively I have a writeup on the internet at http://www.hanford.gov/rl/?page=1144&parent=169 Sartaj Bedi 2nd June 2006, 06:53 PM Hi Try this wedsite ***DEAD LINK REMOVED*** It has a lits of tools all on excel. bobdoering 23rd February 2009, 11:46 PM For precision machining, see Statistical process control for precision machining (http://elsmar.com/Forums/blog.php?b=79). You will find calculations for UCL and LCL for the X hi/lo-R chart. :cool: |
|