Every healthcare organization collects data from its patients, and with access to this data comes the responsibility of securing and using data in applications that are ethical, legal, and with studied outcomes
Cases by City and Ages Impacted Report
Every healthcare organization collects data from its patients, and with access to this data comes the responsibility of securing and using data in applications that are ethical, legal, and with studied outcomes. While organizational health information management supports many of these responsibilities, the decision-makers ultimately shape an organization and its future. In this assessment, you analyze the data provided and consider its potential impact on the scenario.
Part I: Cases by City
Read the following scenario:
Data has been collected to identify specific cases of people who are infected with a dangerous virus. Your organization has an interest in knowing where the population is most affected in an effort to move resources to areas that need them.
Create a bar chart using Microsoft Excel® and the data provided in the Cases by City spreadsheet to identify the cities with the highest counts of cases.
City Date Cases
New York 4/24/2017 189
Los Angeles 4/2/2017 201
Chicago 4/27/2017 14
Houston 4/27/2017 272
Philadelphia 4/24/2017 5
Phoenix 4/2/2017 289
San Antonio 4/7/2017 95
San Diego 4/2/2017 258
Dallas 4/24/2017 83
San Jose 4/23/2017 109
Austin 4/17/2017 281
Jacksonville 4/14/2017 322
San Francisco 4/9/2017 76
Indianapolis 4/11/2017 7
Columbus 4/9/2017 14
Fort Worth 4/29/2017 98
Charlotte 4/10/2017 19
Seattle 4/12/2017 65
Denver 4/2/2017 30
El Paso 4/28/2017 29
Detroit 4/28/2017 35
Washington D.C. 4/3/2017 61
Boston 4/13/2017 28
Memphis 4/25/2017 31
Nashville 4/24/2017 23
Portland 4/2/2017 18
Oklahoma City 4/27/2017 11
Las Vegas 4/27/2017 146
Baltimore 4/24/2017 26
Louisville 4/2/2017 17
Milwaukee 4/7/2017 12
Albuquerque 4/2/2017 51
Tucson 4/24/2017 114
Fresno 4/23/2017 187
Sacramento 4/17/2017 51
Kansas City 4/14/2017 38
Long Beach 4/9/2017 215
Mesa 4/11/2017 231
Atlanta 4/9/2017 220
Colorado Springs 4/29/2017 5
Virginia Beach 4/10/2017 4
Raleigh 4/12/2017 8
Omaha 4/2/2017 3
Miami 4/28/2017 299
Oakland 4/28/2017 84
Minneapolis 4/3/2017 9
Tulsa 4/13/2017 127
Wichita 4/25/2017 83
New Orleans 4/10/2017 248
Arlington 4/12/2017 11
Write a word analysis of the data. Include an answer to the following questions:
What are the top 5 cities for infected cases?
How many infected cases does each of those cities have?
What is the prevalence rate per 100,000 people?
What else can be deduced after evaluating the chart?
Include your bar chart with the analysis.
Part II: Ages Impacted
Now that we know where the outbreaks are located, your organization wants to know more about who it affects. The age of the patient will determine what kind of resources will be needed in those areas.
Create a side-by-side bar graph using Microsoft Excel® and the data provided in the Ages Impacted spreadsheet to identify the age groups affected by the virus.
City Date Cases <18 19-30 31-60 61+
New York 4/24/2017 189 68 15 34 72
Los Angeles 4/2/2017 201 64 16 56 65
Chicago 4/27/2017 14 4 1 3 6
Houston 4/27/2017 272 98 16 52 106
Philadelphia 4/24/2017 5 2 0 1 2
Phoenix 4/2/2017 289 145 20 32 92
San Antonio 4/7/2017 95 46 6 12 31
San Diego 4/2/2017 258 114 15 34 95
Dallas 4/24/2017 83 42 8 12 21
San Jose 4/23/2017 109 49 9 17 31
Austin 4/17/2017 281 151 12 39 79
Jacksonville 4/14/2017 322 93 19 61 149
San Francisco 4/9/2017 76 27 5 25 19
Indianapolis 4/11/2017 7 3 0 1 3
Columbus 4/9/2017 14 7 1 2 4
Fort Worth 4/29/2017 98 47 7 12 32
Charlotte 4/10/2017 19 11 1 2 5
Seattle 4/12/2017 65 36 7 10 12
Denver 4/2/2017 30 16 2 1 11
El Paso 4/28/2017 29 14 2 5 8
Detroit 4/28/2017 35 10 2 7 16
Washington D.C. 4/3/2017 61 22 4 12 23
Boston 4/13/2017 28 10 1 4 13
Memphis 4/25/2017 31 16 2 5 12
Nashville 4/24/2017 23 11 2 2 8
Portland 4/2/2017 18 8 1 2 7
Oklahoma City 4/27/2017 11 6 1 2 2
Las Vegas 4/27/2017 146 59 12 37 41
Baltimore 4/24/2017 26 15 2 2 7
Louisville 4/2/2017 17 5 1 3 8
Milwaukee 4/7/2017 12 4 1 2 5
Albuquerque 4/2/2017 51 19 3 7 22
Tucson 4/24/2017 114 51 8 19 36
Fresno 4/23/2017 187 93 13 19 62
Sacramento 4/17/2017 51 22 3 7 9
Kansas City 4/14/2017 38 19 4 6 9
Long Beach 4/9/2017 215 76 17 40 82
Mesa 4/11/2017 231 129 12 25 65
Atlanta 4/9/2017 220 63 13 42 102
Colorado Springs 4/29/2017 5 2 0 1 2
Virginia Beach 4/10/2017 4 1 0 1 2
Raleigh 4/12/2017 8 4 1 1 2
Omaha 4/2/2017 3 1 0 0 2
Miami 4/28/2017 299 170 18 30 81
Oakland 4/28/2017 84 42 8 18 16
Minneapolis 4/3/2017 9 6 1 1 3
Tulsa 4/13/2017 127 71 10 32 118
Wichita 4/25/2017 83 24 5 22 32
New Orleans 4/10/2017 248 89 15 47 97
Arlington 4/12/2017 11 4 1 2 4
Note: This information will be used for further analysis in future assessments.
Write a word analysis of the data. Include an answer to the following questions:
Which age groups are most affected?
Which age groups are least affected?
What is the prevalence rate per age demographic?
What else can be deduced after evaluating the chart?
Include your side-by-side bar graph with the analysis.
Format your citations according to APA guidelines.
Compile Part I and Part II into a report that could be submitted to the leadership in your organization.
Submit your assignment.
What is missing
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
