Wk 6, mha 507: data plotting and information analysis

While information can point to certain truths and reveal gaps in care that should be addressed, information is neutral until it is assigned a purpose. As you progress in your career, you will continually return to the Triple Aim, which ensures quality management in its clear focus on improving the patient experience, improving the health of populations, and improving the cost of care for patients. This week you consider the best application for information you have learned from your data analyses.

Part I: Plotting Outbreak Data

Now that you know where the outbreaks are located, your organization wants to chart out the areas that pose the highest exposure risk.

Create a graph or chart using the data provided in the High Risk Areas spreadsheet to determine the areas of the country with the most risk.

Note: The chart/graph should be made directly in Microsoft Excel. For additional resources, please visit the Create a Chart MC Excel page, (https://support.microsoft.com/en-us/office/create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2)

Write a 350- to 525-word analysis of the data that answers the following questions:

• Which cities (states) are high risk and low risk?
• Which areas of the country are high risk and low risk?
• What else can be deduced after evaluating the chart?

Include your graph/chart(s) with your analysis, not separately. Label as a “Figure” according to APA formatting. 

Part II: Information Analysis

Compare the charts and graphs you created for the reports in previous assessments and determine conclusions based on the analysis of the data.

Select a health care facility or service (e.g., hospital, physician practice, long-term care facility, ambulance service, pharmacy, or skilled nursing facility).

Write a 700- to 1,050-word analysis, addressing the following:

• Describe how your selected health care facility or service can benefit from the information you gathered and analyzed in the previous assessments.
• Examine any conflicts of interest, ethical considerations, or community health effects that may factor into the benefits identified.
• Identify any points that can be served by further research into either the facility, a service it provides, or the given data.
• Reference data, graphs, and charts to support your claims.

Cite at least 2 scholarly references to support your assignment. Feel free to use supplemental readings from peer-reviewed journals as references. Do not use “.com” commercial, “.edu” education, “.org,” or “.net” proprietary sources. You may use one .gov reference, such as the CDC or NIH.

Compile Part I and Part II into a report that could be submitted to the leadership in your organization.

Format your report according to APA guidelines.