Spreadsheet - Pareto Charts

Sorting And Graphing

 Context:

  • You work at xyz automotive company and receive "defective" returned parts for warranty charge claims.
  • Your boss wants you to create a pareto chart that summarizes the returns for PNxyzi23 rubber engine mount.

    • In this lab exercise you will create a pareto chart (special bar graph) by creating a spread sheet that first lists the causes and their frequency.

    Greater detail about pareto charts can be found by clicking this link to Pareto Charts

     

    Data:

    Categories

    Number

    Bad Rubber

    91

    Cracks

    12

    Cuts

    25

    Impurities

    18

    Poor Adhesion

    124

    Voids

    38

    Other

    11

    You will perform a sort on the data in decending order (highest number to lowest)

    You will finish the spread sheet by summing the total number of defects

    (i.e. =Sum(C3:C26) , and then calculating the % of the total defect cause

    ie. =(C5/Total) use the pull down menu to select the number display. (express the results in %)

    In the last column create a cumulative % column (you add together the previous cumulative % + the % defect ) the column should total 100% at the end.

    Create the bar chart on the sorted data based on the number of defects for each category.

    Finish by writing a cover letter to the warranty manager JJ Houdeshell, at Carillon Motor Company, Dayton Ohio.

    What the final chart might look like:

    Return to Home Page