# An Interactive Look at Process Capability

SPC for Excel Software

SPC Training

SPC Consulting

Ordering Information

Thanks so much for reading our publication. We hope you find it informative and useful. Happy charting and may the data always support your position.

Sincerely,

Dr. Bill McNeese
BPI Consulting, LLC

#### Connect with Us

• pardeepJune 22, 2017

This article is extremely helpful. Thanks a lot for writing this article. It answered almost all doubts I had on process capability. Remaining doubts I am writing here: how you calculate ppm out of spec for diff. Sigma levels. In above artical table no 2  for sigma level 1.5  there is out of spec lsl ppm is 3 and for usl ppm is 66807.  I want to know how you calculate this???

• billJune 23, 2017

Thank you.   In Excel you can calculate the ppm above the USL as:
1000000* (1 – NormSDist((USL- Avg)) / Sigma))
Similar for LSL.

• RamDecember 18, 2019

Hi, can i have step by step method how the cpk requirement set as 1.33

• billDecember 19, 2019

Hello,
I am not sure what you mean.  You can set the Cpk requirement to anything.  Common one is 1.33, which sets the specification 4 sigma from the average.

• PreethamFebruary 8, 2020

Hi,Can u explain difference between sigma and sigma level

• billFebruary 10, 2020

Sigma level is a measure of process capability: the higher the process sigma, the more capable the process is.  Sigma is an estimate of the standard deviation of the process.

• PreethamFebruary 8, 2020

Hi,this excel formula u have given is working only for sigma value= 1, for less than 1 its showing ppm more than lakhs.

• billFebruary 10, 2020

Not sure what you are saying.  Lakhs?

• WillMarch 28, 2020

I work in retail distribution.  We're interested in using SPC for measuring whether our warehouse processes are in control or not.  Any advice for using these concepts for a physical movement of goods vs tolerance for a manufactured item?  Would appreciate any guidance.

• Wen CHENNovember 18, 2020

Hello,6 sigma level with 1.5sigma should be 4.5 sigma level, right? why it becomes 3 sigma level? can you pzl explain, thxBRWen

• billNovember 18, 2020

• SamAugust 27, 2021

Hi…Had a doubt on what is the difference between six sigma and process capability index

• billAugust 27, 2021

A six sigma process (3.4 defects per million) has a Cpk value of 2.0.

• LakiNovember 25, 2021