Pareto Rule

Be sure to complete this assignment using Excel.

$1.$ Given the data below, create 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$?$

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\mathrm{.}369,685$

Digestive System $15,841,269$