5. Onthe next page, I downloaded data from Stats Can, reporting "the number of murders occurring in each Canadian census metropolitan area (CMAs)" across Canada in 2020, along with the reported population of these metropolitan areas. These are cities with at least 100,000 population. a. For each, calculate the "murder rate per 100,000". Which CMA had the lowest, and which had the highest? 2 marks b. Calculate the mean and median of these "rates". 8 marks c. Calculate the appropriate measure of dispersion associated with the murder rates. 10 marks d. The city of Baltimore (USA) had a population in 2020 that was only slightly larger than the CMA of London Ontario (at 585,000 versus 551,066). Yet in 2020, this city was inflicted with 335 murders (which amounts to almost one murder on a daily basis). To put this city's violence into context, how does Baltimore's situation compare with London? (you would obviously want to calculate the appropriate statistic to make this comparison). 7 marks e. Recalculate the mean and median murder rates for all of the Canadian cities, yet this time replace London by Baltimore. What sort of impact does it have on the measures of central tendency? Does this impact differ, depending upon whether you calculate the mean versus the median? Why? 7 marks f. Recalculate the measure of dispersion for these rates (i.e. the rates that include Baltimore rather than London). Does this measure of dispersion change? Why? 8 marks g. Bonus question (i.e. I didn't teach this, but you should be able to figure it out if you think about what the formula tells us): How many murders would London have witnessed in 2020 had it experienced "Baltimore's murder rate". 2 marksFrequency: Annual Table: 35-10-0177-01 (formerly CANSIM 252-0051) number of murders Population St. John's, Newfoundland and Labrador [10001] 10 214,014 Halifax, Nova Scotia [12205] 448,544 Moncton, New Brunswick [13305] 11 12 158,695 Saint John, New Brunswick [13310] 7 10 12 13 131,772 Saguenay, Quebec [24408] 14 15 163,354 Quebec, Quebec [24421] 832,328 Sherbrooke, Quebec [24433] 16 17 224,557 Trois-Rivieres, Quebec [24442] 163,287 Montreal, Quebec [24462] 18 19 20 21 22 23 24 4,364,189 Ottawa-Gatineau, Ontario/Quebec [24505/35505] 25 26 27 28 1,461,494 Kingston, Ontario [35521] 11 176,184 Belleville, Ontario [35522] 11 112,980 Peterborough, Ontario [35529] 11 131,939 Toronto, Ontario [35535] 29 6,555,205 Hamilton, Ontario [35537] 29 804,691 St. Catharines-Niagara, Ontario [35539] 30 437,114 Kitchener-Cambridge-Waterloo, Ontario [35541] 593,882 Brantford, Ontario [35543] 11 151,566 Guelph, Ontario [35550] 11 167,509 London, Ontario [35555] 31 551,066 Windsor, Ontario [35559] 356,880 Barrie, Ontario [35568] 11 218,188 Greater Sudbury, Ontario [35580] 32 172,462 Thunder Bay, Ontario [35595] 126,861 Winnipeg, Manitoba [46602] 7 33 34 35 850,056 Regina, Saskatchewan [47705] 263,184 Saskatoon, Saskatchewan [47725] 336,614 Lethbridge, Alberta [48810] 11 128,851 Calgary, Alberta [48825] 1,543,283 Edmonton, Alberta [48835] 1,468,926 Kelowna, British Columbia [59915] 11 36 37 222,748 Abbotsford-Mission, British Columbia [59932] 11 36 204,265 Vancouver, British Columbia [59933] 36 38 39 40 41 42 43 2,737,698 Victoria, British Columbia [59935] 36 44 408,883 Merely as food for thought: Canada is quite different from the US when it comes to crime/violence, is it not? Perhaps best to draw important distinctions between the two countries, no? I find it endless annoying how many people foil to draw the distinction., and assume what is happening south of the border is comparable to what happens north of the border. While Baltimore is on extreme, the murder rate in the US is typically about 3 times higher than in Canada