Sponsored Link

Sponsored Link

Saturday, September 20, 2008

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.

sixsigma

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!

0 comments:

Post a Comment