Posts

Ontario has a major homicide problem.

 Before we get into the final report, I would just like to address the feedback I've received not only from Chad but from my fellow classmates. It seemed I did not choose the best method to convey what I wanted to with my data. I initially used a line chart to explain my data, hoping it would show that the overall change between the first and final points, however the chart was cluttered and did not clarify that Alberta's overall rate change did not spike as high as the chart showcased. For this reason, I have changed my chart to showcase the percentage change only instead of each rate over the 10 years as well as changed it from a line chart to a bar chart. -- As of 2018, Ontario's major metropolitan areas have seen a significant spike in homicide rates, making it the leading province with multiple major metropolitan areas in increased rates over 10 years according to Statistics Canada.   In looking at the homicide rates of major metropolitan areas in Canada from the y...

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

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 pe...

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

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