1. Plot the frequency distribution for "Age group" & "Total number with BAC". (10)

2. Plot a histogram for "Prevalence of binge drinking percentage" variable. (10)

3. Identify outliers in the "Cost per drink" variable using a visual method. (10)

4. Is there a correlation between "Prevalence of binge drinking percentage" and "Fatalities with BAC"? What is the correlation value and the linear equation representing the relationship? (20)

5. Create a dashboard similar to the one shown below with a synchronized state slider. You can customize the charts and texts as you please. (50)

Age Group	Total number of Drivers Involved	Total Number with BAC	Percentage
16-20	4214	659	16%
21-24	4942	1398	28%
25-34	9860	2623	27%
35-44	7675	1733	23%
45-54	7852	1501	19%
55-64	6453	905	14%
65-74	3767	349	9%
75+	2723	158	6%

State	Total # of fatalities during accidents	Facilties with BAC	Percentage of fatalities with BAC	Prevelance of binge drinking Percentage	Total Cost ($)	Cost per drink ($)	Population
Alabama	849	247	29	12.2	3,724,300,000	2.27	4,852,347
Alaska	65	23	36	20	827,200,000	2.25	737,498
Arizona	893	272	31	15	5,946,400,000	2.27	6,829,676
Arkansas	531	149	28	15.2	2,073,300,000	2.27	2,978,048
California	3176	914	29	16.7	35,010,600,000	2.44	38,918,045
Colorado	546	151	28	18.1	5,056,500,000	2.14	5,450,623
Connecticut	266	103	39	18.3	3,029,000,000	2.04	3,587,122
Delaware	126	41	33	15.8	803,800,000	1.64	941,252
District of Columbia	23	6	26	24.4	918,400,000	6	675,400
Florida	2939	797	27	17.2	15,322,200,000	1.82	20,209,042
Georgia	1430	366	26	15.8	6,930,900,000	2.12	10,178,447
Hawaii	94	33	35	19.8	937,400,000	1.58	1,422,052
Idaho	216	70	32	14.8	1,137,900,000	1.62	1,651,059
Illinois	998	307	31	20.8	9,715,700,000	1.86	12,858,913
Indiana	821	178	22	16.6	4,468,200,000	1.96	6,608,422
Iowa	320	78	24	21.3	1,933,600,000	1.59	3,120,960
Kansas	355	84	24	16.5	2,075,800,000	2.18	2,909,011
Kentucky	761	192	25	16.1	3,194,500,000	2.36	4,425,976
Louisiana	726	245	34	18	3,801,400,000	1.91	4,664,628
Maine	156	52	33	20.2	938,700,000	1.58	1,328,262
Maryland	513	159	31	14.7	4,964,700,000	2.22	5,985,562
Massachusetts	306	96	31	18.7	5,634,600,000	1.93	6,794,228
Michigan	963	267	28	19.8	8,161,700,000	2.1	9,931,715
Minnesota	411	115	28	20.5	3,886,400,000	1.74	5,482,032
Missisippi	677	175	26	12.5	2,277,400,000	2.05	2,988,471
Missouri	869	224	26	17.7	4,603,600,000	1.83	6,071,732
Montana	224	75	34	21.3	870,800,000	1.73	1,030,475
Nebraska	246	65	26	20.4	1,166,500,000	1.61	1,891,277
Nevada	325	97	30	14.5	2,296,300,000	1.49	2,866,939
New Hampshire	114	33	29	17.8	959,900,000	0.3	1,336,350
New Jersey	562	111	20	17	6,175,200,000	1.7	8,867,949
New Mexico	298	98	33	13.6	2,232,900,000	2.77	2,089,291
New York	1121	311	28	17.6	16,330,200,000	2.28	19,654,666
North Carolina	1379	411	30	14.6	7,034,200,000	2.11	10,031,646
North Dakota	131	50	38	24.9	487,600,000	1.4	754,066
Ohio	1110	313	28	19.5	8,519,800,000	2.1	11,617,527
Oklahoma	643	170	27	13.6	3,081,200,000	2.49	3,909,500
Oregon	447	155	35	17.7	3,520,200,000	2.08	4,015,792
Pennsylvania	1200	364	30	18.5	9,544,200,000	1.92	12,784,826
Rhode Island	45	19	43	17	886,500,000	1.82	1,056,065
South Carolina	977	301	31	16.3	3,982,900,000	2.13	4,891,938
South Dakota	133	43	33	17.9	598,200,000	1.59	853,988
Tennesee	958	252	26	10.9	4,683,800,000	2.25	6,591,170
Texas	3516	1323	38	16.1	18,820,600,000	1.99	27,470,056
Utah	276	43	16	11.4	1,636,100,000	2.74	2,981,835
Vermont	57	15	27	19	513,000,000	1.66	625,216
Virginia	753	208	28	17	6,126,000,000	2.06	8,361,808
Wisconsin	568	148	26	16.6	5,805,100,000	2.23	7,163,657
West Virgina	268	71	27	11.8	1,334,900,000	2.2	1,842,050
Washington	566	189	33	24.4	4,452,900,000	1.62	5,760,940
Wyoming	145	56	38	16.9	593,100,000	2.33	585,613