Part I: Cases by City Read the following scenario: Data has been collected to identify specific cases of people who are infected with a dangerous virus.

Part I: Cases by City

Read the following scenario:

Data has been collected to identify specific cases of people who are infected with a dangerous virus. Your organization has an interest in knowing where the population is most affected in an effort to move resources to areas that need them.

Create a bar chart using Microsoft Excel and the data provided in the attached Cases by City spreadsheet to identify the cities with the highest counts of cases.

Write a 525- to 700-word analysis of the data. Include an answer to the following questions:

  • What are the top 5 cities for infected cases?
  • How many infected cases do 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 II: Ages Impacted

Now that we know where the outbreaks are located, your organization wants to know more about who it affects. The age of the patient will determine what kind of resources will be needed in those areas.

Create a side-by-side bar graph using Microsoft Excel and the data provided with the attached Ages Impacted spreadsheet 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 an answer to the following questions:

  • Which age groups are most affected?
  • Which age groups are least affected?
  • 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.

Format your citations according to APA guidelines.

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course,

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we are exploring how the humanities teach us Module Two Project Proposal Guidelines and Rubricinstructions attached  HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we

2-1 Discussion: Diverse PerspectivesPossible Points: 40 Food is a staple in each person’s life. It is a way we learn about cultural values and society.

2-1 Discussion: Diverse PerspectivesPossible Points: 40 Food is a staple in each person’s life. It is a way we learn about cultural values and society. It gives us many different perspectives while simultaneously bringing us all together through shared experiences. Identifying and understanding diverse perspectives adds value to creative works. In

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are designations used to describe complex economic market structures. These represent three of the categories which are further broken down. Keep in mind, perfect markets are a theoretical construct. Case 3 Resources What Does Imperfect

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are designations used to describe complex economic market structures. These represent three of the categories which are further broken down. Keep in mind, perfect markets are a theoretical construct. Case 3 Resources What Does Imperfect

Module 3 – SLPImplications of Market StructuresAssignment Overview Economics and Cryptocurrency Cryptocurrency has supporters and detractors. Is it a

Module 3 – SLPImplications of Market StructuresAssignment Overview Economics and Cryptocurrency Cryptocurrency has supporters and detractors. Is it a tool for transparency in digital transactions? Is it a way to evade taxes or hide net worth? Session Long Project 3 Resources Cryptocurrency Explained With Pros and Cons for Investment (2024)The Crypto

An important aspect of a change management strategy is to consider how different alternatives may impact future outcomes. Organizations often use the

An important aspect of a change management strategy is to consider how different alternatives may impact future outcomes. Organizations often use the business case method to explore strategic alternatives as it helps simulate a real situation. Such simulations help with identifying business issues and provide critical information that organizations can