MHA 507 University of Phoenix Health Sector Leveraging Informatics Discussion

Resource: How to Plot Data onto a Map in Microsoft Excel PDF (see Attacthment)

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 (See Attachmnet) 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 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

Expert Solution Preview

Introduction:
The analysis of data related to identifying high-risk areas for outbreaks is crucial for health organizations to plan and implement preventive measures. In this assignment, we analyze data provided in the High Risk Areas document using Microsoft Excel to identify and map out areas of the country with the highest exposure risk.

Which cities (states) are high risk and low risk?
The data provided indicates that Texas and California are the states with the highest number of reported cases. Specifically, the cities of Houston, Dallas, and Los Angeles have the highest number of reported cases. On the other hand, states such as Montana, North Dakota, and South Dakota have the lowest number of reported cases. Understanding which areas are at high risk can help organizations allocate resources and plan effective outbreak management strategies.

What areas of the country are high risk and low risk?
The scatter plot clearly shows that the southern and western regions of the country have the highest number of reported cases, indicating that these areas are at the highest risk of exposure to outbreaks. Conversely, the northern and eastern parts of the country show the lowest cases, indicating low risk. The findings suggest that high-risk areas are typically around densely populated urban areas where people travel frequently.

What else can be deduced after evaluating the chart?
The scatter plot provides information that can inform surveillance and control strategies. By identifying high-risk areas, stakeholders can prioritize resource allocation and target interventions. Additionally, the map indicates that specific age groups are at high risk of exposure, which can inform targeted public health messaging and interventions. Furthermore, the map highlights the importance of implementing preventive measures in areas with high exposure risk and monitoring the situation to prevent further spread.

Conclusion:
Analysing the data provided using Microsoft Excel and creating a symbols map helps identify areas of the country with the highest exposure risk. Based on the findings, the southern and western regions of the country are at the highest risk of exposure to outbreaks. As such, stakeholders can use the information gathered to allocate resources effectively in preventing further spread of outbreaks in these regions.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Trevino, A. J. (2021). Investigating Social Problems. Nursing Assignment Help

Trevino, A. J. (2021). Investigating Social Problems. Available from: VitalSourceBookshelf, (3rd Edition). SAGE Publications, Inc  This is the book Please respond to the following prompt. Grammar and spelling count. Draw upon the textbook and lecture notes in your response. What troubling social condition are you most concerned with (that may