Using the “Pareto Creator v. 2.0”. Step-by-Step instructions to using the Pareto Creator to develop and print Pareto charts. *These instructions assume that the user knows can access and open the Excel file “Pareto Creator v. 2.0 and knows some very basics regarding Excel spreadsheets.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Step-by-Step instructions to using the Pareto Creator to develop and print Pareto charts.
*These instructions assume that the user knows can access and open the Excel file “Pareto Creator v. 2.0 and knows some very basics regarding Excel spreadsheets.
This screen in the “Tallies” screen. This is where you will place your values and begin building your Pareto Chart.
Only enter information into yellow shaded fields! Entering data into other fields may alter or erase the calculations.
Note the “tabs” at the bottom of your screen- these allow you to navigate to the various charts in the program. Earlier versions of Excel do not provide tab colors- all your tabs may appear gray.
7. Click on the tab corresponding to the Pareto Chart you built to see your chart. (We click on the “4 Item Pareto” tab.)
This line shows the cumulative percentage of responses. This helps you determine where the bulk of the issues lie. In this example, 87% of the children in this class are at or below a 2nd grade fluency level.
The bars show the total number of items in that category. The final bar is a cumulative bar showing the total “N.”
Note that the tab “4 Item Pareto” has been selected and is displaying the Pareto Chart.
To customize the title for the Pareto Chart, simply click the mouse on the existing title. A text box will appear like the one shown below. Click again to begin typing your title. Repeat for the caption.
When finished, print the graph. It prints onto a full size 8 ½ by 11 sheet of paper.
Finally, do a “File” and “Save As” to save the file under the name you desire if you wish to keep this information for later use.