Question: Please help with the step by step and then the complete answer of Q1 and Q2. Thanks! The City of Toronto is Canada's most populous
The City of Toronto is Canada's most populous city and a focal point of development and growth in Canada. As one of the most populous municipalities in North America, significant efforts are being made across all levels of government to manage the challenges posed by Toronto's increased urbanization. Toronto Police Service Public Safety Data Portal is intended to improve the understanding of policing, improve transparency, and enhance confidence through the creation and use of open data for public safety in Toronto. The main objective of this project is to apply your data analytic skills learned in Marketing Analytics 1 and 2 classes using the real-life data. Please use this link https://data.torontopolice.on.ca/datasets/ksi to download the KSI data (CSV file). The dataset includes all traffic collisions events where a person was either Killed or Seriously Injured (KSI) from 2006 - 2019. The attached KSI glossary provides more detailed descriptions of the data. After importing the KSI data into SAS, please work on it and Comment your answers to the following questions in your program. Please feel free to create some tables to better demonstrate your answers if needed. Q1: Aggregate KSI data by ACCNUM, so that each observation is a unique KSI event. a) How many KSI incidents occurred in the city of Toronto from 2006-2019? b) Which is the most incidents district, neighborhood, and location? c) What about the road and weather condition for most KSI incidents? d) How many KSI incidents involving speeding were fatal ? Q2: Transform the aggregated KSI data by Geographic Coordinates (Latitude and Longitude), each observation should be a unique location, so that the KSI number in each unique location can be calculated. What are the top five locations with most KSI incidents in Toronto
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
