Pareto Rule
Please include actual Pareto Chart in answer
Be sure to complete this assignment using Excel.
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
What percent of revenue is generated by the top of MDCs Note: of the number of MDCs in the list is So you would include the top MDCs
MDC Revenue
Blood and blood forming organs
Injury and poisoning
Musculoskeletal system
Infectious and parasitic
Perinatal conditions
Mental
Digestive System
