Learn how to access healthcare databases, analyze the data, and present it in a way that is useful.
Assignment Description:
Statistics Data Collection:
Step One: You are a researcher and collecting statistics from the Agency for Healthcare Research and
Quality (AHRQ) on the top ten MS-DRGs in the nation. In order to complete this, you must visit the AHRQ site from the Healthcare Cost and Utilization Project (HCUP). (http://hcupnet.ahrq.gov/ (Links to an external site.)
Once at the site, you will follow these steps to generate the report you need:
Choose National Statistics on All Stays
Select you are a Researcher, medical professional
Select Rank order specific diagnoses or procedures
Select most recent year
Select Diagnosis Related Groups (DRG)
Select Top 10
Select By hospital charges, mean
Select All patients in all hospitals
Your results will then display in a table that must be converted into a Pareto chart. Develop a Pareto chart
similar to the one in the quality textbook reflecting this data. You will NOT use the standard error columns
given
to you with your results. (Hint: You have several options with which to save your data. If you choose Excel,
you
can easily create the Pareto chart using Excel).
Step Two: Prepare a short summary (about 300 words) which analysis the data presented identifying any
trends in the data.