Create a bar chart using microsoft excel

Reference no: EM133195052 , Length: Word Count: 700 Words

Assignment - Health Care Organization Case Study

Description - Every health care organization collects data from its patients, and with access to this data comes the responsibility of securing and using data in applications that are ethical, legal, and with studied outcomes. While organizational health information management supports many of these responsibilities, the decision makers ultimately shape an organization and its future. In this assessment, you analyze the data provided and consider its potential impact in the scenario.

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 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

Create a bar chart using Microsoft Excel and the data provided in the 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?

Reference no: EM133195052

Questions Cloud

What physical exam will you perform on this patient : Objective data: Blood pressure (BP) 130/84, temperature 98.6, pulse 78, respiratory rate 20. What physical exam will you perform on this patient

Description of the steps of the budget process : University of Purdue Global - Imagine you are a fiscal analyst for a state or local (municipal or county) budget office and budget process from budget

Improving health outcomes of the vulnerable population : Miami Dade College - Illustrate an interdisciplinary approach to improve health outcomes of the vulnerable population. Discuss barriers to healthcare access

Change the u.s. rule, what would you change and why : California Baptist University - What part or parts of the U.S. rule do you either agree or disagree - Compare/contrast the U.S. with your selected country

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

Understand regular expressions in data analytics : When thinking about data visualization, it is important to understand regular expressions in data analytics.

Understanding of social psychology : Western Kentucky University In 1,400 words or less, please describe an incident relevant to social psychology that you experienced or witnessed.

Why do you think they are stated in similar ways : Florida International University - What part or parts of the U.S. rule do you either agree or disagree and Compare/contrast the U.S. with your selected country

Explain primary responsibilities and priorities of irb : Identify an organization, such as a research hospital or pharmaceutical company, that involves human research subjects including all of the following at-risk

User Account

All Pages