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.