Part 1: 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.

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

Make analysis of the data. Include an answer 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?

DATA

Cases by City
City	Date	Cases
New York	4/24/2017	189
Los Angeles	4/2/2017	201
Chicago	4/27/2017	14
Houston	4/27/2017	272
Philadelphia	4/24/2017	5
Phoenix	4/2/2017	289
San Antonio	4/7/2017	95
San Diego	4/2/2017	258
Dallas	4/24/2017	83
San Jose	4/23/2017	109
Austin	4/17/2017	281
Jacksonville	4/14/2017	322
San Francisco	4/9/2017	76
Indianapolis	4/11/2017	7
Columbus	4/9/2017	14
Fort Worth	4/29/2017	98
Charlotte	4/10/2017	19
Seattle	4/12/2017	65
Denver	4/2/2017	30
El Paso	4/28/2017	29
Detroit	4/28/2017	35
Washington D.C.	4/3/2017	61
Boston	4/13/2017	28
Memphis	4/25/2017	31
Nashville	4/24/2017	23
Portland	4/2/2017	18
Oklahoma City	4/27/2017	11
Las Vegas	4/27/2017	146
Baltimore	4/24/2017	26
Louisville	4/2/2017	17
Milwaukee	4/7/2017	12
Albuquerque	4/2/2017	51
Tucson	4/24/2017	114
Fresno	4/23/2017	187
Sacramento	4/17/2017	51
Kansas City	4/14/2017	38
Long Beach	4/9/2017	215
Mesa	4/11/2017	231
Atlanta	4/9/2017	220
Colorado Springs	4/29/2017	5
Virginia Beach	4/10/2017	4
Raleigh	4/12/2017	8
Omaha	4/2/2017	3
Miami	4/28/2017	299
Oakland	4/28/2017	84
Minneapolis	4/3/2017	9
Tulsa	4/13/2017	127
Wichita	4/25/2017	83
New Orleans	4/10/2017	248
Arlington	4/12/2017	11