Description
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 document to identify the cities with the highest counts of cases.
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 (3 References needed)
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached. Please let me know if you have any questions or need revisions.
City
New York
Los Angeles
Chicago
Houston
Philadelphia
Phoenix
San Antonio
San Diego
Dallas
San Jose
Austin
Jacksonville
San Francisco
Indianapolis
Columbus
Fort Worth
Charlotte
Seattle
Denver
El Paso
Detroit
Washington D.C.
Boston
Memphis
Nashville
Portland
Oklahoma City
Las Vegas
Baltimore
Louisville
Milwaukee
Albuquerque
Tucson
Fresno
Sacramento
Kansas City
Long Beach
Mesa
Atlanta
Colorado Springs
Virginia Beach
Raleigh
Omaha
Miami
Oakland
Minneapolis
Cases
189
201
14
272
5
289
95
258
83
109
281
322
76
7
14
98
19
65
30
29
35
61
28
31
23
18
11
146
26
17
12
51
114
187
51
38
215
231
220
5
4
8
3
299
84
9
Date
4/24/2017
4/2/2017
4/27/2017
4/27/2017
4/24/2017
4/2/2017
4/7/2017
4/2/2017
4/24/2017
4/23/2017
4/17/2017
4/14/2017
4/9/2017
4/11/2017
4/9/2017
4/29/2017
4/10/2017
4/12/2017
4/2/2017
4/28/2017
4/28/2017
4/3/2017
4/13/2017
4/25/2017
4/24/2017
4/2/2017
4/27/2017
4/27/2017
4/24/2017
4/2/2017
4/7/2017
4/2/2017
4/24/2017
4/23/2017
4/17/2017
4/14/2017
4/9/2017
4/11/2017
4/9/2017
4/29/2017
4/10/2017
4/12/2017
4/2/2017
4/28/2017
4/28/2017
4/3/2017
11
NEW ORLEANS
TULSA
OAKLAND
OMAHA
VIRGINIA BEACH
ATLANTA
LONG BEACH
SACRAMENTO
TUCSON
MILWAUKEE
BALTIMORE
OKLAHOMA CITY
NASHVILLE
BOSTON
DETROIT
DENVER
CHARLOTTE
COLUMBUS
SAN FRANCISCO
AUSTIN
DALLAS
SAN ANTONIO
PHILADELPHIA
CHICAGO
NEW YORK
83
9
84
3
8
4
5
38
12
17
51
51
26
11
7
18
23
31
28
35
29
30
19
14
61
65
76
83
95
5
14
0
50
100
Tulsa
Wichita
New Orleans
Arlington
127
83
248
11
4/13/2017
4/25/2017
4/10/2017
4/12/2017
CASES
248
127
299
220
231
215
187
114
146
98
322
281
109
258
95
289
272
189
100
150
200
201
250
300
350
Report: WORDREPORT
WORDREPORT
by ...