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 150 words report of your analysis of the data. Include an answer to the following questions:
What else can be deduced after evaluating the chart?
Include your symbols map in the report.
Include three peer-references that support your analysis.
Format your citations according to APA guidelines.