7Week5
Read the following scenario:
Now that you know where the outbreaks are located and which age groups are most affected, your organization wants to map out the areas that pose the highest exposure risk.
Create a symbols map using Microsoft® Excel® and the data provided in the
High Risk Areas
document to determine the areas of the country with the most risk.
Review the “Plotting Data onto a Map in Microsoft® Excel® PDF document for instructions on completing this portion of the assignment.
Write a 350- to 525-word report of your analysis of the data.
Include an answer to the following questions:
· Which cities (states) are high risk and low risk?
· What areas of the country are high risk and low risk?
· What else can be deduced after evaluating the chart?
Include your map within the report, not separately. Label as a Figure according to APA formatting. Also, include title and reference pages.
Cite at least 2 scholarly references to support your assignment. Feel free to use supplemental readings as references, if from peer-reviewed journals. DO NOT use “.com” commercial, “.edu” education, “.org” or “.net” proprietary sources. Okay to use one .gov reference, such as CDC or NIH
Format your citations according to APA guidelines.
>MHA _r _wk5_Tableau_High_Risk
9
6 0 19 0 1 5 9
6 9 3 4 23 28 10 2 13 0 2 7 1 5 8 1 2 19 1 10 2 3 4 4 14 2 1 2 28 2 7 1 4 23 1 6 18 1 1 11 1 22 1 8 26 2 1 3 12 2 15 2 9 13 2 9 51 3 13 38 13 19 5
2 35 11 35 0 0 5 0 0 4 0 2 8 0 0 3 21 72 3 15 1 3 9 8 1 12 83 12 1 2 11
2
5
0
7
1
City
Feb. Cases
March Cases
April Cases
New York
1
9
5
6
1
8
Los Angeles
12
201
Chicago
3
1
4
Houston
19
2
72
Philadelphia
Phoenix
23
78
28
San Antonio
95
San Diego
38
258
Dallas
13
83
San Jose
10
109
Austin
59
281
Jacksonville
97
3
22
San Francisco
76
Indianapolis
Columbus
14
Fort Worth
26
98
Charlotte
Seattle
65
Denver
11
30
El Paso
29
Detroit
35
Washington D.C.
18
61
Boston
Memphis
31
Nashville
Portland
Oklahoma City
Las Vegas
146
Baltimore
Louisville
15
17
Milwaukee
Albuquerque
51
Tucson
114
Fresno
45
187
Sacramento
Kansas City
Long Beach
21
Mesa
231
Atlanta
220
Colorado Springs
Virginia Beach
Raleigh
Omaha
Miami
299
Oakland
84
Minneapolis
Tulsa
43
127
Wichita
New Orleans
101
248
Arlington