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 NOTuse “.com” commercial, “.edu” education, “.org” or “.net” proprietary sources.Okay to use one .gov reference, such as CDC or NIH
Formatyour citations according to APA guidelines. MHA507_r1_wk5_Tableau_High_Risk
City Feb. Cases March Cases April Cases
New York 19 56 189
Los Angeles 6 12 201
Chicago 0 3 14
Houston 19 19 272
Philadelphia 0 1 5
Phoenix 23 78 289
San Antonio 6 9 95
San Diego 3 38 258
Dallas 4 13 83
San Jose 10 23 109
Austin 28 59 281
Jacksonville 10 97 322
San Francisco 2 13 76
Indianapolis 0 2 7
Columbus 1 5 14
Fort Worth 8 26 98
Charlotte 1 2 19
Seattle 1 10 65
Denver 2 11 30
El Paso 3 4 29
Detroit 4 14 35
Washington D.C. 2 18 61
Boston 1 2 28
Memphis 2 7 31
Nashville 1 4 23
Portland 1 6 18
Oklahoma City 1 1 11
Las Vegas 1 22 146
Baltimore 1 8 26
Louisville 2 15 17
Milwaukee 1 3 12
Albuquerque 2 15 51
Tucson 2 9 114
Fresno 13 45 187
Sacramento 2 9 51
Kansas City 3 13 38
Long Beach 13 19 215
Mesa 2 35 231
Atlanta 11 35 220
Colorado Springs 0 0 5
Virginia Beach 0 0 4
Raleigh 0 2 8
Omaha 0 0 3
Miami 21 72 299
Oakland 3 15 84
Minneapolis 1 3 9
Tulsa 8 43 127
Wichita 1 12 83
New Orleans 12 101 248
Arlington 1 2 11