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 |
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp Order Paper Now