Resource: How to Plot Data onto a Map in Microsoft Excel PDF (see Attacthment)
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 (See Attachmnet) 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
Expert Solution Preview
Introduction:
The analysis of data related to identifying high-risk areas for outbreaks is crucial for health organizations to plan and implement preventive measures. In this assignment, we analyze data provided in the High Risk Areas document using Microsoft Excel to identify and map out areas of the country with the highest exposure risk.
Which cities (states) are high risk and low risk?
The data provided indicates that Texas and California are the states with the highest number of reported cases. Specifically, the cities of Houston, Dallas, and Los Angeles have the highest number of reported cases. On the other hand, states such as Montana, North Dakota, and South Dakota have the lowest number of reported cases. Understanding which areas are at high risk can help organizations allocate resources and plan effective outbreak management strategies.
What areas of the country are high risk and low risk?
The scatter plot clearly shows that the southern and western regions of the country have the highest number of reported cases, indicating that these areas are at the highest risk of exposure to outbreaks. Conversely, the northern and eastern parts of the country show the lowest cases, indicating low risk. The findings suggest that high-risk areas are typically around densely populated urban areas where people travel frequently.
What else can be deduced after evaluating the chart?
The scatter plot provides information that can inform surveillance and control strategies. By identifying high-risk areas, stakeholders can prioritize resource allocation and target interventions. Additionally, the map indicates that specific age groups are at high risk of exposure, which can inform targeted public health messaging and interventions. Furthermore, the map highlights the importance of implementing preventive measures in areas with high exposure risk and monitoring the situation to prevent further spread.
Conclusion:
Analysing the data provided using Microsoft Excel and creating a symbols map helps identify areas of the country with the highest exposure risk. Based on the findings, the southern and western regions of the country are at the highest risk of exposure to outbreaks. As such, stakeholders can use the information gathered to allocate resources effectively in preventing further spread of outbreaks in these regions.