Categorized | excel tips, others, six sigma

Six Sigma Calculator in Excel

How do you make a six sigma calculator in Excel? Well it’s all really quite simple in excel….the calculator needs only a single formula to generate the sigma level for a process!!! You simply plug the number of opportunities & defects into an excel spreadsheet and calculate the sigma level by using NORMSINV (1 – defect/opportunities). You can download a copy of the six sigma calculator in excel here.


Before you use this calculator, a word of caution! There is a difference between the immediate sigma level as measured for a process right after making a process improvement and the one that a practitioner will typically report. The reason is that it is usually observed, that over a period of time, with more data being available, any future measurements of the standard deviation of a process would tend to be lower (and sigma levels tend to be higher). In the short term, we compensate for the non-availability of those additional data points by adding 1.5 to the measured sigma level so that the immediate and the long term sigma levels are not to far off. The number you arrive at by adding 1.5 to the immediate sigma level is then reported as the sigma level of a process.

Definitions of the data elements used as inputs by the six sigma calculator in Excel

Defect is defined as a non-conformance of a part or a process to the desired specification (shape, color, length, width, tolerance, hours, number of transactions).
Opportunities for defects are defined as the number of chances that a given part or a process could have resulted in a defect.

For some of my readers who might be wondering what this is all about…..well….the idea behind some of these and other forthcoming posts is to create a free repository of six sigma tools, all of course using Microsoft Excel. No subscription, no installation and all absolutely free. You may also want to download the six sigma table.

For the uninitiated, Six Sigma is a technique that seeks to improve the output of a process by identifying and eliminating the causes of defects (called errors) and variation in processes (standard deviation).

Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Comments and Trackbacks

  1. JaneRadriges wrote:

    The best information i have found exactly here. Keep going Thank you

  2. toya wrote:

  3. Jatin Nailwal wrote:

    I got the good file which i needed most.

  4. Julie wrote:

    Thank you. 🙂
    I’ve been looking for this. You’re the best.

  5. Ashwani Sharma wrote:

    Lots of valuable matrial for information and knowledge

  1. da TaB is On » Six Sigma Table wrote:

    […] A4 sheet and act as a ready reckoner for a six sigma practitioner. You may also want to look at the six sigma calculator that was made in excel. Related ArticlesSix Sigma Calculator in ExcelHouse of Quality Template in […]


Keep up with the latest stories - Delivered right to your inbox


English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel