I now know that the ward who receives the most noise complaints (at least in the year 2015), is Ward 12 or Rideau-Vanier. After acquiring the 311 service requests data from data.ottawa.ca, I downloaded the values for the first nine months of the year, January to September. I then used a pivot table for each month’s file, sorting the rows by ward and the values by the number of complaints received. After the pivot table was created, I took each table and put them into one document. Next, I added up all the values for each month by ward and sorted them into a final table of their own, adding the total number of noise complaint calls together. Finally, I used rapidtables.com to pull my findings up on a bar graph to better represent the data.

The total number of 311 calls regarding noise amounted to 8106 for the first nine months of the year. Rideau-Vanier took the crown with 1717 complaints, with Somerset ward coming in at 1172.