Data considerations for Pareto Chart

To ensure that your results are valid, consider the following guidelines when you collect data, perform the analysis, and interpret your results.

Collect summary data or raw data
You can create the chart with summarized data or raw data. For summarized data, each observation summarizes a category. Summarized data can be a count or a calculated value, such as a mean. For raw data, each observation is an occurrence or a defect. All the raw data are in one column of the worksheet, with each observation in a separate row.