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 Areasdocument to determine the areas of the country with the most risk.
Note: “How to Plot Data onto a Map in Microsoft Excel” offers more information about plotting data on a map in Excel®. Also note that this information will be used for further analysis in Week Six.
Write a 350- to 525-word report 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.
Format your citations according to APA guidelines.