Using the inpatient data for all DRG codes, create a pivot table that shows the number of cases by payor. Recall that Count counts one per record (there's one record per row) and you can change Sum to Count as described in part e in Question 0 and it doesn't matter which field you do a count on. a Pivot Table in a separate worksheet and then copying it and doing Paste Value and then answering the following questions by doing additional analysis on the resulting data: a) Which Payor covered the most procedures? b) How many did they cover? c) Divide the number of procedures covered by each Payor by the total number of procedures done to calculate market share data for each Payor. Sort them in decreasing order of market share. What is the market share of the Payor with the highest market share? d) How many Payors have more than 5% market share? e) What is the total market share of the four federal government plans (Medicare, Medicare HMO, Medicaid, and Medicaid HMO?