# The Lambda Lambda lambda Fraternity polled its members on the weekend party theme. The vote was as follows: 18 for toga, 12 for hayride, 24 for beerbash and 6 for masquerade. How do I display the count on a pareto chart? And can this be explained please?

Question

The Lambda Lambda lambda Fraternity polled its members on the weekend party theme. The vote was as follows: 18 for toga, 12 for hayride, 24 for beerbash and 6 for masquerade. How do I display the count on a pareto chart? And can this be explained please?

Step 1

A Pareto chart is defined as a chart which is a combination of both bars and a line graph. Here, individual values are represented by bars in descending order and the cumulative total is represented by the line.

Step 2

The Pareto chart is constructed using Excel whose steps are following:

Step 1: Sort the data in the descending order and compute its cumulative frequency.

Step 2: Go to Insert > Charts.

Step 3: Go to All Charts > Combo > Select secondary axis in the line type and...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in