Data Update 2

-

 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 percentage changes. I've included both the percentage change from 2009 to 2017 and 2009 to 2019 to showcase that if there had not been such a huge spike of homicides in 2018, they would not have been the only metropolitan area with an increased rate. 

Original Dataset Link

This is the link to the revised data set I have chosen to use. 

News Story/Study Link and Brief Summary

I believe this news article that is paying respects to the 96 homicide victims of 2018 is relevant to my data. This article talks about the 96 homicide victims in city of Toronto alone. This is relevant to my data because it sheds some light on why Toronto had such a massive spike in 2018, which inevitably bled into 2019. 

Comments

  1. Wilson Wong11 March 2021 at 21:57

    Hello Coco,

    I really liked the news article you chose to try and explain your data. It helps shed some light on the "why" of the data, which adds a lot of interest. One suggestion I would have is to use the actual percentage change of the homicide rates instead of saying "significant spike". It doesn't provide much of a reference point for the reader to compare without looking at the data.

    ReplyDelete
  2. Colin Syms13 March 2021 at 19:51

    Hey Coco,

    I like what you have here, this is a good start to analysis along with your news article, the article helps back up and further the stance you are taking.

    I do like the intro you put in, helps to tie everything together

    ReplyDelete
  3. Lakeisha Barrington14 March 2021 at 16:24

    Hi Coco,

    I really like your lead. It made me go, "wow! really?" I would read this article. My only bit of advice for you is to simplify the presentation of your percentage changes in your Slice by changing the decimal place, as Chad mentions in his video lectures. Other than that, I think you've done a fine job.

    ReplyDelete
  4. Matthew DiMera14 March 2021 at 16:33

    Hi Coco, I really appreciated your explanation of why you made certain changes. Also I like the article you picked, it will help answer the "why?" I think your lead would be stronger with some more clarity about the "significant spike," — I'd want to see some specific numbers.

    ReplyDelete

Post a Comment

Popular posts from this blog

Data Update1

-
Hello and welcome to my blog post on my idea for my Final Data Report. I will be answering the four questions provided now. 1. What dataset will you use for your final report? (title of your dataset, include a link to it and claim it at the URL above). The data set I will be using is the one titled "Number, rate, and percentage changes in rates of homicide victims"  from the Statistics Canada page.   2. Describe the dataset. What kind of data does it contain? This dataset contains information regarding the number of homicide victims per year, rate per 100,000 population, and yearly percent changes across a ten year span between 2009 and 2019. As well, it provides a 10 year comparison of the percentage change in homicide rates.   3. Is there anything about your data that you don’t understand? (i.e. what a column heading means). How will you find this out? Something about my data I don't fully understand is why every year has a "percent change in homicide rates, 1...
Read more

Data Update 3

-
 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...
Read more

Data Visualization Analysis - The Most Popular Dog Breeds

-
Image
The data visualization chart  created by Anjushree B V on the most popular dog breeds does a decent job at explaining and displaying the data. It displays an easy to understand list of the top dog breeds and colour coordinates the dogs to the circular line graph.  The data visualization chart is simple enough that the key only needs two items that help explain the line segments well. Moreover, when you hover over the lines, you will get a box that restates which dog breed's line you're on and when you click a line, it highlights the line segment for the year you are clicking in. However, there are a couple reasons why displaying data this way is not the best. First, turning what would have been a very easy to follow line graph spherical, made it hard to follow the lines even though they are all differently coloured.  As well, pairing that with having the lines abruptly end and restart when a dog breed does not make it into the top ten list for that year is difficult to fo...
Read more