Epidemiology Statistics

Epidemiology Statistics
W5-Stats Exercise
Complete each of the following questions in an Excel file and submit to Blackboard for grading along with a Microsoft Word file.
Please upload 2 documents for each this assignment, 1 Word, and 1 Excel.
Click on the title of the assignment above.
1. Please do not round your results up or down unless specifically asked to do so in the instructions.
2. Be sure to label all tables, charts, results, graphs, etc. according to the requirements outlined in Chapter 11.
Directions:
Using the Horton textbook, select 3 exercises from each chapter assigned this week and noted below. Using Excel, respond to the question(s) posed by the author to present your calculations, results, and analysis. Be sure to show your work on each response and put each question on a new sheet in the Excel document.
• Chapter 6 Exercises: 6.3, 6.5, 6.11, 6.15, or 6.17
• Chapter 7 Exercises: 7.3, 7.8, 7.9, or 7.13
• Chapter 8 Exercises: 8.3, 8.5, 8.9, 8.11, or 8.13

Week 6 – Quality of Care and Medical Research
W6 Stats Exercise
1. Please do not round your results up or down unless specifically asked to do so in the instructions.
2. Be sure to label all tables, charts, results, graphs, etc. according to the requirements outlined in Chapter 11.
Questions
For all requirements, content must be original and all external sources cited per APA requirements. 2 pages
1. Using DHHS’s website titled Department of Health and Human Services Office of Research Integrity (https://ori.hhs.gov/), select the link titled Misconduct Case Summaries. Select a specific case study that is within the past 5 years and report on the following:
o Overview of the case including specific research misconduct (use your own words vs. copying/pasting from the website to exhibit your knowledge and understanding).
o Consequences of misconduct to the patient(s) and the healthcare organization
o Examine the role HIM and the medical record would have played in the misconduct case. What data and/or documentation recommendations would you make to minimize its recurrence?
2. Research the case of Henrietta Lacks at the Johns Hopkins University or other .edu or .gov sites. Report the following:
o Overview of the case including specific research misconduct (use your own words vs. copying/pasting to exhibit your knowledge and understanding).
o Consequences of misconduct to the patient(s) and the healthcare organization
o Examine the role HIM and the medical record can play to minimize this type of misconduct or its recurrence.
3. Using the Clinical Trials link in the lecture, select a clinical research trial of your choice and examine it further using the foundation of the topics in Chapter 12. After presenting an overview of the research, discuss four of the following to present:
o Type of research being conducted and research methodology being used
o Types of data being collect and analyzed including data collection techniques and instrument
o Hypothesis
o Selection of sample and sample size
o IRB team and processes
o Bias
o Ethical practices being implemented
o Confidentiality and privacy processes

Week 7 – Statistics in the Health Information Management (HIM) Department
W7-Stats Exercise
Complete each of the following questions in an Excel file and submit to Blackboard for grading along with a Microsoft Word file.
Please upload 2 documents for each this assignment, 1 Word, and 1 Excel.
1. Please do not round your results up or down unless specifically asked to do so in the instructions.
2. Be sure to label all tables, charts, results, graphs, etc. according to the requirements outlined in Chapter 11.
Questions
1. As the HIM director of a small community hospital, you are required to prepare a budget for the department and submit to your executive management team. As part of the budget, the evaluation of salaries is part of the analysis. Three employees are eligible for pay raises during the next fiscal year, which is the calendar year for this organization. Your CFO has informed you that your allotted budget should not exceed 6% of the original base salaries for these 3 employees.
Complete the table for the following employees and proposed pay raises for each percentage based on the following data. Also, answer the question, do the proposed increases meet/exceed the 6% allowed by your CFO? Please explain.
Please show your work in the cell to evaluate the calculations and result.
1. The Coder/Analyst I is getting a 5% raise at the beginning of the calendar/fiscal year.
2. The ROI Specialist/Analyst II is getting a 4% raise at the beginning of the calendar/fiscal year.
3. The Coding Compliance Specialist/Analyst III is getting 2.5% a raise at the beginning of the calendar/fiscal year.
1A: Does your proposed increase meet/exceed the 6% allowed by your CFO? Please explain.
Calculations are based on:
• 40 hour work week (2080 hours in a year).
• Reminder: 52 weeks in a year
Position or Title Current Base Yearly Salary Proposed Raise New Base Yearly Salary
Coder/Analyst I $24,000
ROI Specialist/Analyst II $26,000
Coding Compliance Specialist/Analyst III $37,000
Total $87,000

2. A full-time coder at Community Hospital who works 40 hours and makes $26.00 an hour. Calculate the following:
A: Weekly salary?
B. Bi-weekly salary?
B: Yearly salary?
C. Total yearly compensation if the base benefit was 25%?

3. As the new HIM Director, you are presented with the following situation that you need to make a decision on. First, you need an FTE inpatient coder and found out that the beginning salary in the area is $27.00/hour and your hospital provide a 22% benefits package for FT employees. Secondly, the hospital is using a temporary service that is charging $7.00/record that is coded and the average weekly records coded are 250 by the current coder.

Calculate the yearly costs of the temporary employee and the FT employee. Then examine which would be the best financial situation for the HIM department and explain your rationale.

W8-Healthcare Statistics Reflections- 1 page
Self-reflection at the end of a course helps students to be self-aware and appreciate how you learn. It also allows students to re-evaluate their learning behaviors and make any modifications for future course, particularly when the subject matter is challenging like healthcare statistics.
In reflecting on the past 7 weeks, what are you most proud of about your collective learning and thinking of healthcare statistics?
What areas of healthcare statistics do you still struggle with? Would you like assistance this last week from your peers and/or the professor? Please explain.
How can you continue your learning of healthcare statistics as a future HIM professional?
Your discussions will be evaluated based on the course requirements outlined in the grading rubric.