using HCUPnet to find the most common procedures in Massachusetts, the most expensive procedures in Massachusetts, and the least expensive procedures in Massachusetts.

HCUPnet Exercises:
Turn in a single Microsoft Excel workbook with a worksheet for each exercise (1a – 3). Label the worksheet you want me to grade with the exercise number. e.g. “1a”. To get full credit you must turn in all of your worksheets (as part of the workbook) so I can see your work.
Using Inpatient Setting, SID database (Diagnoses and Procedures) from HCUPnet answer the following questions:
https://hcupnet.ahrq.gov
1a. (2 points) In Massachusetts what were the 10 most common procedures in 2020?
• use Medicare Severity-Diagnosis Related Group (MS-DRG) for the procedure codes
• download the data into an excel spreadsheet
• analyze the data in Excel to find the the 10 most common procedures (number of discharges)
• show your results using the appropriate graph
1b. (2 points) In Massachusetts what were the 10 most expensive procedures in 2020?
• use Medicare Severity-Diagnosis Related Group (MS-DRG) for the procedure codes
• download the data into an excel spreadsheet
• analyze the data in Excel to find the the 10 most expensive procedures (average hospital charges per stay)
• show your results using the appropriate graph
1c. (2 points) In Massachusetts what were the 10 least expensive procedures in 2020?
• use Medicare Severity-Diagnosis Related Group (MS-DRG) for the procedure codes
• download the data into an excel spreadsheet
• analyze the data in Excel to find the the 10 least expensive procedures (average hospital charges per stay)
• graph your results using the appropriate graph
2a. (3 points) Show the trends in number of procedures in Massachusetts from 2010 – 2020 for the 2020 5 most common procedures.
• use Medicare Severity-Diagnosis Related Group (MS-DRG) for the procedure codes
• download the data into an excel spreadsheet
• analyze the data in Excel to find the 2020 5 most common procedures (number of discharges)
• show the number of procedures (number of discharges) for the 2020 5 most common procedures (number of discharges) from years 2010 to 2020 using the appropriate graph
2b. (3 points) Show the trends in cost for procedures in Massachusetts from 2010 – 2020 for the 2020 5 most common procedures.
• use Medicare Severity-Diagnosis Related Group (MS-DRG) for the procedure codes
• download the data into an excel spreadsheet
• analyze the data in Excel to find the 2020 5 most common procedures (number of discharges)
• show the cost of procedure (average hospital charges per stay) for the 2020 5 most common procedures (number of discharges) from years 2010 to 2020 using the appropriate graph
2c. (3 points) Show the top 10 procedures in Massachusetts that had the greatest increase in cost from 2016 – 2020.
• use Medicare Severity-Diagnosis Related Group (MS-DRG) for the procedure codes
• download the data into an excel spreadsheet
• analyze the data in Excel to find the 10 procedures in Massachusetts that had the greatest increase in cost (average hospital charges per stay) from 2016 – 2020.
• show your results using the appropriate graph
3. (5 points) For the 2020 5 most common procedures in Massachusetts, show a comparison of number of procedures done, cost for procedure, number of deaths, and percentage of deaths across Maine, Massachusetts, New York, Rhode Island, and Vermont.
• use Medicare Severity-Diagnosis Related Group (MS-DRG) for the procedure codes
• download the data (number of discharges) into an Excel spreadsheet for Massachusetts
• analyze the data in Excel to find the 2020 5 most common procedures (number of discharges) in Massachusetts
• download the data (number of procedures done, cost for procedure, number of deaths, percentage of deaths) for the 2020 5 most common procedures in Massachusetts for each of the New England states into an Excel spreadsheet.
• combine the state data onto a single worksheet
• analyze the data
• for the 2020 5 most common procedures in Massachusetts, show the number of procedures (number of discharges), cost for procedure (average hospital charges per stay), number of deaths (Discharge(N): In-hospital deaths), and percentage of deaths (Discharge(%): In-hospital deaths) for Maine, Massachusetts, New York, Rhode Island, and Vermont using the appropriate graph(s). [no more than 5 graphs. You get bonus points if you use a single graph].
• Which state would be your choice for each of the 5 most common procedures, and why?