Reference no: EM132160732
Assignment -
Objectives: Meet CAHIIM Curriculum requirement for Associate Degree Domain I. Data Content Structure and Standards Subdomain I.D. Data Management Section
Apply graphical tools for data presentations Competencies: Graphical tools Meet CAHIIM Curriculum requirement for Bachelor Degree Domain I. Data Content Structure and Standards Subdomain I.D. Data Management Section.
Evaluate data from varying sources to create meaningful presentations Competencies: Indices and registries.
Purpose: Learn how to access healthcare databases, analyze the date, 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). 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.
Step Three: Analyze why the top-ranked DRG is the most costly for hospitals even though it does not have the most patients. Use resources to help you write a one-page summary in APA format. Include a reference page for any resources used. Parameters: You will submit your Pareto chart with the following data elements: Rank, DRG (name not required), Total number of discharges, and charges (mean) and your one-page summary analysis. Submit your data analysis summary Submit your analysis of the top-ranked DRG.
Attachment:- Assignment File.rar