Wk 5 - Practice: Pareto Charts
Assignment Content
- There are several tools and techniques featured in the textbook that are used for quality control in IT projects. A Pareto chart is a type of histogram that can be used to define quality problems in a system. It allows you to see what areas need improvement.
Create a Pareto chart based on the information below. Use the Pareto Chart template. You can also do the math and create the graph in Excel, but people who do get it wrong more often than the ones who use the template. List the most frequent customer problems first. On the graph, it should be the tallest bar first, then the next largest, and so on. The second item in the graph, after the bars, is the cumulative line and it should always go up from left to right, all the way to 100%. If you see a dip in the line, your problems are not listed in the correct order. Check your entries so your resulting chart looks like the one in Figure 8-7 in the textbook.
Customer Complaints; Frequency/Week
Customer is on hold too long; 90
Customer gets transferred to wrong area or cut off; 20
Service rep cannot answer customer’s questions; 120
Service rep does not follow through as promised; 40
Submit your chart.
- PS. Note from me- Luis. Google "Excel Pareto chart"
5 years ago
15
Answer(2)![blurred-text]()
![]()
![blurred-text]()
![]()
Purchase the answer to view it

- Pareto.xlsx
Purchase the answer to view it

NOT RATED
- BESTANSWERPareto.xlsx
other Questions(10)
- Wk 6MM
- quiz
- what is the density of an unkown substance with a mass of 2.5g that was dropped into a graduated cylinder...
- Due in 1 hour 30 minutes. Copy the answers from the pics and type them below the respective questions.
- Is there Any one doing toturing for Supply chain management classes in Tempe az
- Write a program that calculates several possible tips to give to a waiter at a restaurant. Ask the user to...
- .
- Short Paper: Grant Proposal
- Health Since
- Art Forum