Calculate Six Sigma in Excel

Sigma is calculated using error and number of opportunities. At times, people need different tool for calculating Sigma. At times, people even search in Google. I wish if you reach here and understand Sigma calculation once an and all in MS Excel.

1. The Six Sigma mainly consist defects/error and Total number of opportunities.
2. Please check the formula in the image below. For reference use, it's mentioned below.

Formula:

=IF(A2=0,6,IF(A2=B2,0,IF(B2=0, "DENOMINATOR CANNOT BE ZERO",ROUND((NORMSINV(1-A2/B2)+1.5),2))))

If you like this post, spend two minutes in leaving comments. To receive update over email do subscribe to us.

We assure you knowledge, not SPAM!