Competency Assessment Title: Cases by City and Ages Impacted Report.
Assignment Directions
A dangerous virus has broken out, and the health care organization you work for needs to react. Which are the most affected areas? What are the patient demographics, and what resources are needed? Your job is to analyze available data and report it to your organization’s leadership team.
Part 1: Cases by City
Review the Cases by City spreadsheet.
Create a bar chart using Microsoft Excel® to identify cities with the highest counts of cases.
Write a 525- to 700-word analysis of the data. Include your answers to the following questions:
• What are the top 5 cities for infected cases?
• How many infected cases does each of those cities have?
• What is the prevalence rate per 100,000 people?
• What else can be deduced after evaluating the chart?
Include your bar chart with the analysis.
Part 2: Ages Impacted
Now your organization wants to know who the virus is hitting hardest. Patient ages affect what kind of resources are needed in affected areas.
Review the Ages Impacted spreadsheet.
Create a side-by-side bar graph using Microsoft Excel® to identify the age groups affected by the virus. (Note: This information will be used for further analysis in future assessments.)
Write a 525- to 700-word analysis of the data. Include your answers to the following questions:
• Which age groups are most affected?
• Which age groups are least affected?
Copyright 2022 by University of Phoenix. All rights reserved.
MHACB/507 Competency 2 Rubric
Page 2 of 4
• What is the prevalence rate per age demographic?
• What else can be deduced after evaluating the chart? Include your side-by-side bar graph with the analysis. Compile Part 1 and Part 2 into a single report.
Do you need help with this assignment or any other? We got you! Place your order and leave the rest to our experts.