Sigma Level In Excel

This video explains the Excel formulae required for calculating the standard deviation, sample mean, DPMO (Defects per Million Opportunities), Short term and Long term sigma levels, P Value for USL (Upper Specification Limit) and LSL (Lower Specification Limit).
We can learn the following this video:
From a given process sample data, how to find the mean and standard deviation.
From a given sample process data how to find the process capabilities for a given customer. (to meet a given customer requirements).
From a given sample process data and for a given customer, How do we get our DPMO and sigma levels.
From defects or defectives data (Discrete data) how do we get DPMO and short term and long term sigma levels.
What is the short term term and long term sigma levels for a given DPMO?
How do we write cell formulae in Excel for my life time use and get process capability values (Sigma levels)?
You learn both the subject as well Excel in this video.
Excel files will be available from the author for free downloads.

[@mks5555]

REALLY VERY NICE , FOR THOSE ONE WHO WANT TO CALCULATE THE DPMO / CP/CPK ......, SIX SIGMA (LONG TERM ) , SIX SIGMA( SHORT TERM IN EXCEL.

[@MadanKumar-uy4iu]

Its really useful videos in this channel. Very sad that subscribe count is very low

[@wpadilla72]

Hi, Can you sahre the excel file please?

[@aristotlereyes7817]

This is interesting, but I hope the speaker can talk slower. Not all listeners can keep up with his speed.