Creating comparative Pareto charts

Plot a series of Pareto charts to identify the most frequently occurring quality-related problems stratified by up to 2 factors.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Pareto, and then click Comparative Pareto Chart.
    The analysis task pane opens.
  3. In the Variable drop-down list, select the categorical variable.
  4. If the data are in frequency form, in the Frequency drop-down list, select the frequency count variable.
  5. In either or both the Factor (column) and Factor (row) drop-down lists, select the categorical stratification variables.
  6. In the Primary axis drop-down list, select:
    Option Description
    Count Show the frequency of occurrence or unit of measurement.
    Percent Show the percentage of the total frequency or a total of the unit of measurement.
  7. Optional: To force the primary and secondary axis so that 1 unit on the primary axis is equal to the percentage of the total on the secondary axis, select the Lock axes scales check box.
  8. Optional: To label the bars, select the Label bars check box.
  9. Optional: To label the line, select the Label cumulative line check box
  10. Optional: In the Layout drop-down list, select:
    Option Description
    Flow Layout the plots across the width of the page, before flowing onto a new row.
    Matrix Layout the plots in a matrix as defined by the row and column factors.
  11. Click Calculate.