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.

2

>MHA

5 0 7

_r

1

_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

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