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

Copyof20180126222034mha507_r1_wk3_casesbycity__1_.xlsx
 

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.

Don't use plagiarized sources. Get Your Custom Essay on
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
Just from $13/Page
Order Essay

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

Note: This information will be used for further analysis in future assignments.

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

  • What are the top five 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 in the report.

Format your citations according to APA guidelines.

Sheet1

/24/1

4/27/17

9

4/2/17

4/24/17

/17

/17

7

4/9/17 14

/17

/17

4/2/17

29

4/28/17

28

4/24/17 23

4/2/17 18

4/27/17 11

4/27/17

4/24/17

4/2/17 17

4/7/17 12

4/2/17

4/24/17

4/17/17 51

4/14/17

4/9/17

4/9/17

5

4/10/17 4

8

4/2/17 3

4/28/17

4/28/17

4/3/17 9

4/13/17

4/25/17

4/10/17

4/12/17 11

City Date Cases
New York 4 7 1

8 9
Los Angeles 4/2/

17 201
Chicago 4/27/17 14
Houston 272
Philadelphia 4/24/17 5
Phoenix 4/2/17 28
San Antonio 4/7/17 95
San Diego 258
Dallas 8

3
San Jose 4/

23 109
Austin 4/17/17 281
Jacksonville 4/14/17 322
San Francisco 4/9/17 76
Indianapolis 4/

11
Columbus
Fort Worth 4/

29 98
Charlotte 4/10/17 19
Seattle 4/

12 65
Denver 30
El Paso 4/28/17
Detroit 35
Washington D.C. 4/3/17 61
Boston 4/13/17
Memphis 4/25/17 31
Nashville
Portland
Oklahoma City
Las Vegas 146
Baltimore 26
Louisville
Milwaukee
Albuquerque 51
Tucson 114
Fresno 4/23/17 187
Sacramento
Kansas City 38
Long Beach 215
Mesa 4/11/17 231
Atlanta 220
Colorado Springs 4/29/17
Virginia Beach
Raleigh 4/12/17
Omaha
Miami 299
Oakland 84
Minneapolis
Tulsa 127
Wichita 83
New Orleans 248
Arlington

Sheet2

Sheet3

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper