Customer sales dataset- HW 1
age group
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%
states
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