Plotting map data in excel and analysis report | MHA507 Leveraging Informatics In The Health Sector | University of Phoenix

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 attached “High Risk Areas” Excel Spreadsheet 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

  Format your citations according to APA guidelines.