Part I: Plotting Data on a Map
Resource: 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 spreadsheet to determine the areas of the country with the most risk.
Review Plotting Data onto a Map in Microsoft Excel for instructions on completing this portion of the assignment. Write a 350- to 525-word analysis of the data that answers 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 with your analysis, not separately. Label as a “Figure” according to APA guidelines.