Question

At Comp4U you have tracked warranty claims from your customers for the last month. Here is the list of problems and the number of times each occurred:

Monitor not working        5

Wires loose                     6

RAM bad                         30

CD ROM drive bad           2

Mouse defective 18

Software conflicts             8

Modem defective   4

Draw a Pareto chart using this data.  Note that a Pareto chart always go left to right, largest to smallest.

Answer 1

Ordering the problems in descending order

Problem	No.
RAM bad	30
Mouse defective	18
Software conflicts	8
Wired loose	6
Monitor not working	5
Modem defective	4
CDROM drive bad	2

Using excel Pareto chart, we get -

The Pareto Chart can be found under Histogram Tab as shown below