Coco Shabbir's JRNL 3165 Blog

 Hello and welcome to my third Data Update. Before we begin, I would like to address Chad's feedback. As per his feedback, I have broadened my search to the top ten major metropolitan areas by population instead of limiting myself solely to those with a population above 1 million. With these new data points to consider, Toronto was not the only major metropolitan area to see an increased rate. However, Ontario in general had a higher rate compared to the other provinces so I find that it's just as important and relevant. I would also like to point out that although, per the data, Quebec City is considered the metropolitan area with the highest rate change, it is an outlier with 2 homicides in 2009 and 5 in 2019 and therefore excluded from the final data. Chart Unanswered Question Not including homicide, is there an increased crime rate in these metropolitan areas and, if so, what type of crime has there been an influx of? How would you get the data? I would search Statistics...

 Hello and welcome to my second data update. I'd like to preface this by stating that per Chad's suggestion, I am using a new data set that looks at the homicide rates in major metropolitan areas rather than just per province. As well, Chad had stated that the questions I had asked in Data Update 1 focused too much on individual data points. As such, I want to go forward and focus more on compare and contrast questions instead of questions solely relying on effective use of excel.  Lead Statement As of 2018, the Toronto metropolitan area has seen a significant spike in homicide rates, making it the only major metropolitan area with a population of 1 million plus that has an increased rate over 10 years. Excel Workbook Link and Explanation Here is a link to my slice workbook  which shows not only the raw data, but also the homicide rate data of the five biggest metropolitan areas in Canada (Calgary, Edmonton, Montréal, Toronto, and Vancouver) from 2009 to 2019, with the pe...