Now that we know where the outbreaks are located, your organization wants to know more about who is affected. The age of the patient will determine what kind of resources will be needed in those areas.

Create a side-by-side bar graph using Microsoft Excel and the data provided in theAges Impacted document to identify the age groups affected by the virus.

Explain your analysis of the data. Include answers to the following questions:

• Which age groups are most affected?
• Which age groups are least affected?
• What is the prevalence rate per age demographic?
• What else can be deduced after evaluating the chart?

Include your side-by-side bar graph in the report.

City	Date	Cases	<18	19-30	31-60	61+
New York	4/24/2017	189	68	15	34	72
Los Angeles	4/2/2017	201	64	16	56	65
Chicago	4/27/2017	14	4	1	3	6
Houston	4/27/2017	272	98	16	52	106
Philadelphia	4/24/2017	5	2	0	1	2
Phoenix	4/2/2017	289	145	20	32	92
San Antonio	4/7/2017	95	46	6	12	31
San Diego	4/2/2017	258	114	15	34	95
Dallas	4/24/2017	83	42	8	12	21
San Jose	4/23/2017	109	49	9	17	31
Austin	4/17/2017	281	151	12	39	79
Jacksonville	4/14/2017	322	93	19	61	149
San Francisco	4/9/2017	76	27	5	25	19
Indianapolis	4/11/2017	7	3	0	1	3
Columbus	4/9/2017	14	7	1	2	4
Fort Worth	4/29/2017	98	47	7	12	32
Charlotte	4/10/2017	19	11	1	2	5
Seattle	4/12/2017	65	36	7	10	12
Denver	4/2/2017	30	16	2	1	11
El Paso	4/28/2017	29	14	2	5	8
Detroit	4/28/2017	35	10	2	7	16
Washington D.C.	4/3/2017	61	22	4	12	23
Boston	4/13/2017	28	10	1	4	13
Memphis	4/25/2017	31	16	2	5	12
Nashville	4/24/2017	23	11	2	2	8
Portland	4/2/2017	18	8	1	2	7
Oklahoma City	4/27/2017	11	6	1	2	2
Las Vegas	4/27/2017	146	59	12	37	41
Baltimore	4/24/2017	26	15	2	2	7
Louisville	4/2/2017	17	5	1	3	8
Milwaukee	4/7/2017	12	4	1	2	5
Albuquerque	4/2/2017	51	19	3	7	22
Tucson	4/24/2017	114	51	8	19	36
Fresno	4/23/2017	187	93	13	19	62
Sacramento	4/17/2017	51	22	3	7	9
Kansas City	4/14/2017	38	19	4	6	9
Long Beach	4/9/2017	215	76	17	40	82
Mesa	4/11/2017	231	129	12	25	65
Atlanta	4/9/2017	220	63	13	42	102
Colorado Springs	4/29/2017	5	2	0	1	2
Virginia Beach	4/10/2017	4	1	0	1	2
Raleigh	4/12/2017	8	4	1	1	2
Omaha	4/2/2017	3	1	0	0	2
Miami	4/28/2017	299	170	18	30	81
Oakland	4/28/2017	84	42	8	18	16
Minneapolis	4/3/2017	9	6	1	1	3
Tulsa	4/13/2017	127	71	10	32	118
Wichita	4/25/2017	83	24	5	22	32
New Orleans	4/10/2017	248	89	15	47	97
Arlington	4/12/2017	11	4	1	2	4