SPC Excel Toolkit: Control Charts, Process Capability (Cpk) and Gage R&R

Description
Every process varies. The question that matters is whether today's variation is normal, or whether something genuinely changed. Get that wrong in one direction and you adjust a machine that was fine, doubling your variation. Get it wrong in the other and you ship a month of defective product before anyone notices.
Statistical Process Control answers that question, and this workbook does the statistics for you.

Thirteen working sheets. A selector that names the right chart for your data from four questions. Seven control charts with the correct constants already built in, from individuals through to subgroups of 25, and for counted defects as well as measurements. Every out-of-control rule evaluated automatically for every point, with a sheet that tells you what each signal usually means, what to do, and the common wrong reaction.

Process capability: Cp, Cpk, Pp, Ppk, parts per million outside specification, and a written interpretation. It reports short term and long term performance separately and tells you which one to quote to a customer.

And a complete Gage R&R study, because the first question about any measurement is whether the measurement itself can be trusted. Ten parts, three operators, two trials, with %GRR against both study variation and tolerance, and a verdict that tells you whether the problem is the gauge or the people using it.
No macros, no add-ins, no subscription. Sample data on every sheet so you can see it working in thirty seconds. Written by a Six Sigma Master Black Belt running a live deployment in manufacturing.

New to project definition rather than analysis? Myfree Six Sigma Project Starter Kit covers the charter, the benefit calculationand the first 90 days. Download that one first.