Given the data below, make a Pareto chart reporting the major diagnostic categories (MDCs) with the highest inpatient revenue first (on the left) to the lowest revenue last (on the right).

2. What percent of revenue is generated by the top 20% of MDCs? Note: 20% of 7 (the number of MDCs in the list) is 1.4. So, you would include the top 2 MDCs. Explain how this STEP by STEP on Excel!

MDC	Revenue
Blood and blood forming organs	1,668,475
Injury and poisoning	1,803,197
Musculoskeletal system	14,137,767
Infectious and parasitic	3,458,147
Perinatal conditions	3,923,030
Mental	9.369,685
Digestive System	15,841,269