The table lists the number of albums by The Beatles that recei...

Question

The table lists the number of albums by The Beatles that received sales certifications. Display the data using (b) a Pareto chart. (Source: Recording Industry Association of America)

Pareto chart showing The Beatles' album sales certifications: Gold 48, Platinum 42, Multi-Platinum 26, Diamond 6.

Accepted Answer

All right. Hello, everyone. So, this question says, the table shows the number of defective products reported by 5 different departments in a manufacturing unit over 1 month. Display the data using a Paretto chart. So here, let's take a moment to order the departments by the number of defects from highest to lowest. The highest number of defects goes to Department C with a total of 25. Afterwards you have A with 18. I was 14 B with 12 and D with 7. So now, let's find the total number of defects. And so to find the total number, that's going to be the sum of all of the defects for each department. So the sum Of 25, 1814, 12, and 7. Is Equal to 76. From here we can calculate the total number. Or the cumulative number of defects for each department. And for this, I'm actually going to move the ordered list towards the left side of the screen here. So for the cumulative number of defects, you start with the ordered list. Because Department C is the first with 25 defects. The cumulative defects for Department C is just equal to 25. However, The next department, department A. Has the number of cumulative defects equal to 25 added to 18, which gives you 43. And so for each subsequent department, what you're doing is adding the total number of defects of that specific department to the cumulative total. So for E, for example, that's 43 added to 14, which gives you 57. For B, that's 57, added to 12, which gives you 69. And for D. That's 69 added to 7, which equals 76. And now you can calculate the cumulative percentage for each department. Which is the cumulative total for that department, divided by the total, which if you recall, is 76. And then to make it a percentage you would multiply the decimal by 100. So for Department C, for example, that's 25 divided by 76, multiplied by 100, which gives you 32.9%. For Department A, that's 56.6%. For E that's 75.0%. For B, that's 90.8%. And for D, that's 100%. And now you have the information needed for the Pareto chart. So recall that for the Pareto chart, you would need to have both bars and lines. So the bars. Represent the total number of defects. In each department, in descending order. So you're starting with the department that has the highest number of defects, all the way down to the department with the least. And then, the lines overlapping the bars represent the cumulative percentages across all departments. So ultimately, The Paretto chart should look as follows. Here you can see the bars representing the number of defective products specific for each department. And then overlapping it, you can see a red line representing the cumulative percentage for each department. Across all departments rather. And there you have it. So with that being said, thank you so very much for watching, and I hope you found this helpful.

The table lists the number of albums by The Beatles that received sales certifications. Display the data using (b) a Pareto chart. (Source: Recording Industry Association of America)

Key Concepts

Pareto Chart

Sales Certifications

Data Visualization

Watch next