How to Plot Data onto a Map in Microsoft Excel
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 275-350 -word report of your analysis of the data.
Include an answer to the following questions:
o Which cities (states) are high risk and low risk?
o What areas of the country are high risk and low risk?
o What else can be deduced after evaluating the chart