Any ideas on setting up Capability Study spreadsheet in Excel? (CPK/CMK formulae)

[bagpuss]

I wanna set up a cap study spread sheet on excel. Any one got any ideas on setting up the formula??

 

[Rick Goodson]

I am not sure I understand your question. The formula are the same ones you would use if doing a manual study and can be found in any good SPC book. Is it the statistics side or the Excel side you are having problems with?

 

[Al Dyer]

Try the following file in the FTP site. The second page has a basic chart that will do CP/CPK/PP/CPK and is easily modified. Be sure to verify the formulas before you make decisions based on the file!

ASD...

Bias-Linearity_WS.xls

 

[Bagpuss]

Sorry. I'm new at this. What is the FTP site. Thanks for the info!!

 

[Rick Goodson]

Index of /pdf_files You will be in a file of documents that you can view on your browser or download to your computer. The majority of the files are pdf files (you need Adobe Acrobat Reader to see them), doc files (Microsoft Word), or xls files (Microsoft Excel). Click on the document name to see it.