7Week5 Read the following scenario: Now that you know where the outbreaks are located and which age groups are most affected, your organization wa

7Week5

Read the following scenario:

Don't use plagiarized sources. Get Your Custom Assignment on
7Week5 Read the following scenario: Now that you know where the outbreaks are located and which age groups are most affected, your organization wa
From as Little as $13/Page

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