As a data manager, you are often tasked with developing graphs for various projects, committees, and focus groups. The Revenue Taskforce would like you to develop a set of graphs to analyze the number of patient visits, length of stay, and payment methods. You will compile a presentation of findings for the next meeting.
- Using the sample patient file create at least three graphs.
- Create a 6-8 slide PowerPoint presentation to include:Title slideIntroductionCopy of your graphs (at least three)Explanation of why each graph was the most effective method for the data set – using graphical perspective and data visualization as a foundation to the explanationA brief analysis of each graph – identify trends or summarize resultsReference Slide
Submit your presentation.
Resources & Tips
- Go to YouTube and search MS Excel Graph Tutorial, to learn more about how to create graphs.
- Data Visualization – What it is and why it Matters
- Types of Graphs
- Sophia
- HIMA460_Assignment 3_Sample Patient Data.xls
Month
Number of visits
January
3321
February 2547
March
2287
April
2346
May
2254
June
1896
July
2154
August
2215
September 2415
October
2715
November 3015
December 3315
Length of Stay
31
30
25
20
18
14
12
11
20
22
28
30
Type of Insurance
Blue Cross
Cigna
Other Commercial
Medicare
Medicaid
Private-Uninsured
% of Patients
12%
6%
5%
38%
21%
18%
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
