Read the following scenario:

Consider data that has been collected to identify specific cases of people who have been infected with a dangerous virus example; Influenza, or CV19.

Your organization has an interest in knowing where the population is most affected in an effort to move resources to areas that need them, therefore,

Create a bar chart or graph using Microsoft Excel and with data charting of a case study provided Cases by City document to identify the cities with the highest counts of cases example; (graphic).

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

Write a 350- to 525-word report of your current 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.