Step by Step Pareto for Excel program

The Pareto diagram is a bar or column chart in which data is arranged in descending order of importance. The diagram is really two charts in one. The bar chart plots the descending data, and the cumulative chart represents the percentage of each bar to the total. A good example of using Pareto diagram can be described with the following example:

A company wants to determine which product to work on to reduce overall cost. The data of the returned product over the last four months is collected. 

Case A - Pareto for Total

Step 1 - Start Pareto for Excel program (Start => Programs => Pareto for Excel => PFX106A.XLS)

Step 2 - Collect the data and enter the data in Excel worksheet

Step 3 - Select the data with the first column being the CAUSE and then the data 

               Note: Select two more column with blank data. The minimum number of column needs to be 4.

Step 4 - Choose the Pareto for Excel option from the Excel Tools menu.

Step 5 - Make sure that you de-select all "Build Preto..." and "The Selected Data.." options and then click OK.

Step 6 - Review the results.

Case B - Pareto for Data

Step 1 - Start Pareto for Excel program (Start => Programs => Pareto for Excel => PFX106A.XLS)

Step 2 - Collect the data and enter the data in Excel worksheet (Case_01.XLS)

Step 3 -  Select the header and the data (Cell A2 to N8)

Step 4 - Choose the Pareto for Excel option from the Excel Tools menu.