Six Sigma Table

A Six sigma table is a table that depicts the (six) sigma value corresponding to various accuracy levels. The six sigma table can be downloaded here. By looking down the tabulated values of the accuracy levels, you can find the (six) sigma level that corresponds to your accuracy level. The sigma table has five columns – the yield or the accuracy level ( 1 ...

Six Sigma Calculator in Excel

Posted on 11 May 2009

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 ...

House of Quality Template in Excel

Posted on 10 May 2009

You can download the house of quality template in excel here. House of quality is a graphic tool analyzing the relationship between a firm's focus on improvement and the needs of its customers.It is a part of the Quality Function Deployment (QFD). Visually, it looks like a grid with a correlation matrix at its top and left side. The customer needs vs the firm's product features form the main body of the house of quality. Using this template in ...

How to create a Gantt Chart in Excel

Posted on 07 May 2009

This article shows how to make Gantt charts in excel. Though Excel remains the preferred choice for creating simple Gantt charts, there are other commercial tools available for developing more complex versions of the Gantt chart. GANTT Charts are an important project management tool. In this article, I will describe how to create gantt chart in excel with a marker for show today's date. Using a stacked chart in excel, we ...

How to Create a Pareto Chart in Excel

Posted on 05 May 2009

Find out how to create a Pareto chart in Excel. A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line chart. A Pareto chart (also known as the Pareto graph) is a combination of two data series, one set of points representing a set of independent values and the other representing the cumulative sum of those values. The independent values are typically represented by vertical bars in which the values are arranged ...

How to create an Excel Flow Chart – (Template and Software)

Posted on 04 May 2009

This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to download and analyze this sample flowchart template created using excel. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...