**6** **sigma**, also known as **process sigma**, is an important factor when it comes to the production process. Obviously, you have heard this term if you are a production specialist or working in the industrial sector. In this article, we’ll demonstrate 2 easy and quick methods on how to do 6 sigma calculation in Excel. So, let’s go through the entire article to understand the topic properly.

**Table of Contents**Expand

## What Is 6 Sigma?

There are differences of opinion regarding 6 Sigma. Some claim that it is a quantitative and analytical symbol. It is referred to as an organizational strategy by others. And many assert that it is a paradigm for development. They’re all accurate.

In many organizations, the term “**6 Sigma**” refers to a quality measurement that aims for absolute flawlessness. 6 Sigma is a methodical, computation approach for reducing errors in any process, from production to procedural, from goods to servicing, by aiming for six standard deviations between the mean and the closest specification limit.

## Importance of 6 Sigma in Production

Although individual outcomes may have varied, there are a basic set of benefits that all firms that have adopted 6 sigma should have attained. They are as follows:

- Increased efficaciousness, performance, and productivity.
- Enhanced product and service quality, as well as a decrease in waste.
- Decreased operational costs and volatility in the process.
- Improved client satisfaction and ambitious edge.
- Greater interaction and involvement of employees.

## How to Do 6 Sigma Calculation in Excel: 2 Methods

The calculation of 6 sigma involves two different approaches. The first one is when the data is discrete. And another one is for continuous data. We’ll discuss these two types in the following part of the article. So, let’s be with us.

Here, we have used *Microsoft Excel 365* version, you may use any other version according to your convenience.

### 1. Calculation of 6 Sigma When Data Are Discrete

In our first method, we’ll exhibit how you can do 6 sigma calculation for discrete data in Excel. Discrete data is a sort of quantitative value that consists of entire, concrete numbers with predetermined, set values that can be counted. So, let’s follow us carefully.

**📌**** Steps:**

Here, we have got the ** Number of Units**,

**and Total**

*Number of Opportunities,***in cells in the**

*Number of Defects***C4:C6**range.

Here, ** U**,

**and**

*O,***represent the**

*D***, the**

*Number of Units***, and the**

*Number of Opportunities***correspondingly.**

*Number of Defects*Now, we have to calculate the

**which is defects per opportunity from the previous data. The generic formula to find it is the following.**

*DPO***DPO = D / ( U * O )**

To do the task in Excel,

- Firstly, create an output range in cell
**C8**.

- Secondly, select cell
**C8**and enter the following formula in the cell.

`=C6/(C4*C5)`

- Then, press the
**ENTER**key.

The universal formula to get the value of ** 6 Sigma** from

**is the following.**

*DPO***6 Sigma = – NORMSINV (DPO) + 1.5**

So, we can easily replicate this in Excel.

- Thirdly, go to cell
**C10**and insert the formula below.

`=-NORMSINV(C8)+1.5`

The **NORMSINV function** returns the inverse of the normal distribution.

- After that, hit
**ENTER**.

That’s how we can calculate the 6 sigma value for discrete data.

### 2. Calculation of 6 Sigma When Data Are Continuous in Excel

In the previous method, we saw the approach to find out the value of 6 sigma for discrete data. But, in this example, we’ll do the calculation for a continuous dataset.

Here, we are using a report on the **Size of Samples of ABC Corporation**. This dataset includes the **Sample** numbers and their corresponding **Sizes** in columns **B** and **C** respectively.

Note that this is a basic dataset to keep things simple. In a practical scenario, you may encounter a much larger and more complex dataset.

Now, we’ll use this dataset to do the 6 sigma calculation in Excel. It’s simple & easy, just follow along. So, let’s begin.

**📌**** Steps:**

At first, we mentioned the ** LSL** and

**for this dataset. These two terms mean**

*USL***and**

*Lower Specification Limit***subsequently. Here, the ideal size is**

*Upper Specification Limit***32**. We presumed that the purchaser is inclined to acknowledge the product with a size variation of

**. So the**

*+/-1***and**

*LSL***should be**

*USL***31**and

**33**.

`=AVERAGE(C5:C24)`

Using the **AVERAGE function**, we calculated the ** Mean** of this data. Here,

**C5:C24**represents the entire data range.

- Following this, tap the
**ENTER**key.

- Currently, go to cell
**F8**and paste the formula below.

`=STDEV(C5:C24)`

The **STDEV function** calculates the standard deviation of any dataset.

- As always, press
**ENTER**.

Forthwith, we calculate *C***_{pu}** and

*C***for this dataset. Based on the system’s upper specification limit, the**

_{pl}

*C***is an indicator of its conceivable competence. This goes the same for**

_{pu}

*C***but it’s just based on the lower specification limit, that’s the difference. So, see below to learn to calculate these two terminologies.**

_{pl}- At first, select cell
**F10**and enter the following formula.

`=(F5-F7)/F8`

- After that, press
**ENTER**.

So, the value of *C***_{pu}** is 0.07263.

- Again, go to cell
**F11**and put down the formula below.

`=(F7-F4)/F8`

- As usual, tap
**ENTER**.

The ** 6 Sigma Value** would be the minimum value between the values of

*C***and**

_{pu}

*C***divided by the standard deviation.**

_{pl}- So, navigate to cell
**F13**and insert the following formula.

`=MIN(F10:F11)/F8`

The **MIN function** returns the minimum value from a range of cells.

- As always, hit the
**ENTER**key.

Finally, we got the value of 6 sigma for this continuous data.

**Read More:**How to Calculate Sigma Level in Excel

## How to Calculate 3 Sigma in Excel

As a bonus, we’ll show how you can calculate 3 sigma values in Excel. To do this, we’ll use the same dataset. So, without further delay, let’s see how to do it.

**📌**** Steps:**

- First of all, calculate the mean like
**before**. - Then, select cell
**F5**and write down the following formula in the cell.

`=VAR(C5:C24)`

The **VAR function** returns the variance of a sample taken from population data.

- Afterward, press
**ENTER**.

- Later, select cell
**F6**and paste the following formula.

`=SQRT(F5)`

The **SQRT function** returns the square root of any number. Actually, we are finding out the standard deviation from the square root of the variance.

- Next, press
**ENTER**.

- Presently, go to cell
**F8**and introduce the formula below.

`=3*F6`

- As usual, press
**ENTER**.

Basically, it’s equal to thrice the standard deviation.

- Now, add the
value with the*Mean*to get*3 Sigma Value*.*High End Value*

`=F8+F4`

- Additionally, you can extract the
by subtracting the*Low End Value*from the*Mean*.*3 Sigma Value*

`=F8-F4`

## Practice Section

For doing practice by yourself we have provided a **Practice** section like the one below in each sheet on the right side. Please do it by yourself.

## Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.

## Conclusion

This article explains how to do 6 sigma calculation in Excel in a simple and concise manner. Don’t forget to download the Practice file. Thank you for reading this article. We hope this was helpful. Please let us know in the comment section if you have any queries or suggestions.

## Related Article

**<< Go Back to Calculate Sigma in Excel | Excel for Statistics | Learn Excel**