Densities/Rates/Trends/Compar 1. The engineering department within the City of Somewhereville, a moderately-sized city on the outskirts of the metropolitan area of Conglomerateville, is planning projects for the next year. As part of the planning analysis, the department is considering comparative safety aspects of several potential project sites, separating the analysis into segment-based sites and intersection-based sites. Having analyzed safety in the traditional manner for multiple decades, departmental personnel decide to begin with calculations for the sites using these familiar methods. As the safety analyst for the department, you are tasked with calculating the annualized crash frequencies (intersections), densities (segments), and crash rates (both intersections and segments). (40 points) Segment-based Sites: For both total crashes and severe crashes, provide 5-year densities and rates (ie., total density, total rate, severe density, severe rate) for each site and, as the analysis is inherently comparativelop rankings for cach density (crashes/mile/year) and rate (crashes/HMVMT). Are these rankings consistent? Would they necessarily need to be? Also, comment on apparent trends (i.e., year-to-year) within the data. (20 points) Segment-based Sites 2 AADT (average for 5 years) 32,000 31,000 19,000 Length (miles) 2.5 1.7 18 Total Crashes 2017 56 40 58 2018 63 39 58 2019 65 38 64 2020 64 35 66 2021 58 33 69 Severe Crashes 2017 8 3 5 2018 12 2 4 2019 13 4 9 2020 11 4 11 2021 7 12 3 Intersection-based Sites: For both total crashes and severe crashes, provide 5-year densities and rates (ie., total density, total rate, severe density, severe rate) for each site and, as the analysis is inherently comparative, develop rankings for each density (crashes/year) and rate (crashes/MEV). Are these rankings consistent? Would they necessarily need to be? Also, comment on apparent trends (i.e., year-to-year) within the data. (20 points) Intersection-based Sites 1 2 3 AADTajor (average for 5 years) 21,000 24,000 19,000 AADTminor (average for 5 years) 8,000 7,000 5,000 Total Crashes 2017 30 46 53 2018 32 53 53 2019 31 55 61 2020 33 54 63 2021 32 48 66 Severe Crashes 2017 6 6 6 2018. 4 10 5 2019 5 11 11 2020 2021 9 68 12 13 5 14