Question
Below are data for 122 significant crashes on I-65 in the Birmingham region in 2015, arranged in order of resulting congestion. The first column is
Below are data for 122 significant crashes on I-65 in the Birmingham region in 2015, arranged in order of resulting congestion. The first column is simply an ID number assigned to that crash. The second column shows the congestion resulting from that incident, expressed in vehicle-hours. (As an example, if you had 100 vehicles stuck behind the crash and each one was delayed by 30 minutes, your total delay would be 100 veh x 0.5 hours each = 50 veh-hrs.) Look at the data: the bottom 15 incidents (1-15) account for only about 2% of total congestion for the year, whereas the top 15 crashes (108-122) account for almost 33% of the total delay experienced over the course of the year. Present all this data graphically in a way that emphasizes that the top 15 incidents account for a large percentage of total congestion for the year, and thus should be the focus of incident management efforts
This is all the information provided, just show me how to put this data in a graph, highlighting the 108-122 data.
vehicle-hours of delay caused 168 236 284 Incident Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 358 382 401 404 472 479 511 518 550 559 630 636 680 683 694 783 831 876 882 884 913 960 984 1020 1030 1208 1211 1240 1243 1311 1314 1317 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 1318 1319 1328 1333 1347 1390 1437 1441 1482 1498 1500 1539 1572 1621 1628 1698 1732 1735 1744 1749 1750 1772 1772 1789 1818 1850 1882 1895 1920 1941 1946 1980 2075 2092 2167 2210 7777 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 2277 2340 2426 2436 2532 2558 2587 2657 2675 2681 2724 2730 2775 2892 2898 2919 2988 3089 3098 3161 3216 3275 3385 3442 3543 3707 3826 4121 4311 4353 4616 4652 4833 4933 5219 5239 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 5471 5478 5584 6489 6733 7243 7262 7555 7605 7625 8268 8382 8582 8950 9433 vehicle-hours of delay caused 168 236 284 Incident Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 358 382 401 404 472 479 511 518 550 559 630 636 680 683 694 783 831 876 882 884 913 960 984 1020 1030 1208 1211 1240 1243 1311 1314 1317 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 1318 1319 1328 1333 1347 1390 1437 1441 1482 1498 1500 1539 1572 1621 1628 1698 1732 1735 1744 1749 1750 1772 1772 1789 1818 1850 1882 1895 1920 1941 1946 1980 2075 2092 2167 2210 7777 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 2277 2340 2426 2436 2532 2558 2587 2657 2675 2681 2724 2730 2775 2892 2898 2919 2988 3089 3098 3161 3216 3275 3385 3442 3543 3707 3826 4121 4311 4353 4616 4652 4833 4933 5219 5239 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 5471 5478 5584 6489 6733 7243 7262 7555 7605 7625 8268 8382 8582 8950 9433Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started