For this assignment you will generate two Pareto Charts using QI Macros. For your convenience I have included an excel data set below which you may use to create your charts. Please create a Pareto chart for TWO of the data elements (you may choose from among any of the options). Make sure to create labels for your chart; the automatically generated labels are not, in general, appropriate for data presentation. Along with your Pareto Chart construction, you will provide a brief analysis of the chart. This can take the form of a brief description of your findings (no more than a paragraph is necessary).
1.
Pareto Chart
ICU Pro
BG
BG/lytes
BG/lactate
BG/Co-ox
Cap
Cap 0
100
200
300
400
500
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
315
202
34
6
3
3
1
55.9%
91.7%
97.7%
98.8%
99.3%
99.8%
Pareto Chart for Types of Blood Gas Test Ordered
Type of Blood Gases
Number of Orders per Blood Gas Type
The Pareto Chart above displays the amount of blood gases order per blood gas type. We can easily see that 315 ICU Pro blood gases were ordered the most resulting in 55.9% of the types of blood gases ordered, followed by 202 BG only orders, 34 BG with lytes, 6 blood gases with lactates, 3 blood gases with co-oximetry, 3 Capillary, and 1 Capillary blood gas.
