Resource: How to Plot Data onto a Map in Microsoft Excel PDF
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.
Expert Solution Preview
Introduction:
This report analyzes the provided data on high risk areas in the United States and presents a symbols map created using Microsoft Excel. The map represents the areas with the most risk of exposure to outbreaks. The analysis includes identification of high and low-risk cities and states, areas of high and low risk in the country, and other findings resulting from the evaluation of the chart.
Which cities (states) are high risk and low risk?
According to the symbols map, the high-risk states are New York, Florida, California, and Texas. These states are shown in red, representing the highest risk for exposure to outbreaks. On the other hand, the low-risk states are Montana, Wyoming, North Dakota, and South Dakota, as indicated by the green color. Overall, the map shows that the eastern and western coasts are high-risk areas while the mid-west region is low-risk.
What areas of the country are high risk and low risk?
As previously mentioned, the eastern and western coasts are high-risk areas. However, the map reveals that the risk is higher in metropolitan areas such as Los Angeles, San Francisco, New York City, and Miami. In contrast, the low-risk areas are surrounding the high-risk areas, such as rural Montana, Wyoming, North Dakota, and South Dakota.
What else can be deduced after evaluating the chart?
After evaluating the chart, it is evident that certain patterns can be observed. The metropolitan areas are at a higher risk of exposure as compared to the rural areas. Additionally, there is a correlation between population density and the risk of exposure. More densely populated areas have a higher risk of exposure as compared to low population density areas. It is also important to note that the high-risk areas are not distributed evenly throughout the country. The eastern and western coasts are at more risk due to higher population density and international travel than the central states.
Conclusion:
In conclusion, the symbols map created using Microsoft Excel provides an excellent visual representation of the high and low-risk areas in the United States. It reveals the patterns of exposure risk, which are crucial in the formulation of preventive measures against outbreaks. The analysis of the chart sheds light on the correlation between population density, location, and the risk of exposure to outbreaks. It highlights that the highest risk areas are metropolitan and coastal regions. This report concludes that understanding the patterns of exposure is the first step towards implementing effective prevention measures against outbreaks.