1
MHA 507 Week 5 Report 3 Now that you know where the outbreaks are located and which age
groups are most affected, your organization
Resources: How to Plot Data onto a Map in Microsoft Excel
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.
Note: Watch the “How to Plot Data onto a Map in Microsoft Excel” video for more information
about plotting data on a map in Excel. Note also that this information will be used for further
analysis in Week 6.
Write a 350- to 525-word report or create a 5- to 7-slide presentation of your analysis of the
data. Include an answer to the following questions:
Which cities 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 symbols map in the report.
Include three peer-references that support your analysis.
, 2
Report 3
Now that we know more specifics such as which months the outbreak occurred, the ages
most affected we can now go deeper and look at the cities affect the most more in dept. I have
created a symbols map; this shows which cities were included in the data and the severity of the
cases. We are able to look at which cities are high risk, and which are low risk, also we can see
which part of the country is affected more.
High and low risk cities
Looking at the map and data you can see that there are three months were the outbreak
was present. The cities with the highest risk were those with cases reaching 300-429 cases those
cities were as follows: Houston Texas with 310 cases, New Orleans with 361 cases, Austin
Texas with 368 cases, Phoenix Arizona with 390 cases, Miami Florida with 392 cases and finally
Jacksonville Florida with 429 cases.
The lower risk cities had very few in range from 3 cases to 9 they are as follows: Omaha
with 3 cases, Virginia beach with 4 cases, Colorado springs with 5 cases, Philadelphia with 6
cases and finally Indianapolis with 9 cases there were others that were also low risk but they
ranged in 10- 299. As they should all be taken seriously the low numbers mean there were better
odds at less outbreaks to spread.
Low and high-risk area in country
The United States has a lot of out breaks, but there also areas that the outbreak area is
very minimal. Looking at the low risk areas I feel that the north west part of the united states had
very few the whole area had a total of 105 out breaks. Which to some it may seem like a lot but
when it comes to the numbers and map its not that much. I feel that the highest risk areas are
located in mostly the South West part of the country. They had a total of 3,916 cases. Which
MHA 507 Week 5 Report 3 Now that you know where the outbreaks are located and which age
groups are most affected, your organization
Resources: How to Plot Data onto a Map in Microsoft Excel
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.
Note: Watch the “How to Plot Data onto a Map in Microsoft Excel” video for more information
about plotting data on a map in Excel. Note also that this information will be used for further
analysis in Week 6.
Write a 350- to 525-word report or create a 5- to 7-slide presentation of your analysis of the
data. Include an answer to the following questions:
Which cities 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 symbols map in the report.
Include three peer-references that support your analysis.
, 2
Report 3
Now that we know more specifics such as which months the outbreak occurred, the ages
most affected we can now go deeper and look at the cities affect the most more in dept. I have
created a symbols map; this shows which cities were included in the data and the severity of the
cases. We are able to look at which cities are high risk, and which are low risk, also we can see
which part of the country is affected more.
High and low risk cities
Looking at the map and data you can see that there are three months were the outbreak
was present. The cities with the highest risk were those with cases reaching 300-429 cases those
cities were as follows: Houston Texas with 310 cases, New Orleans with 361 cases, Austin
Texas with 368 cases, Phoenix Arizona with 390 cases, Miami Florida with 392 cases and finally
Jacksonville Florida with 429 cases.
The lower risk cities had very few in range from 3 cases to 9 they are as follows: Omaha
with 3 cases, Virginia beach with 4 cases, Colorado springs with 5 cases, Philadelphia with 6
cases and finally Indianapolis with 9 cases there were others that were also low risk but they
ranged in 10- 299. As they should all be taken seriously the low numbers mean there were better
odds at less outbreaks to spread.
Low and high-risk area in country
The United States has a lot of out breaks, but there also areas that the outbreak area is
very minimal. Looking at the low risk areas I feel that the north west part of the united states had
very few the whole area had a total of 105 out breaks. Which to some it may seem like a lot but
when it comes to the numbers and map its not that much. I feel that the highest risk areas are
located in mostly the South West part of the country. They had a total of 3,916 cases. Which
