As an example of precision journalism, we’re working through how to gather and sort data in an excel file. I sort of followed the tutorial, but also created my own function to add up all the different types of crimes in each province, and display one total amount.
Here it is!
In row C109, we can see the total amount of crimes in all of the provinces in Italy in 2011. (Retrieved using the =SUM function, adding the total of all the different types of crimes per province).