A walkthrough of managing earthquake data and doing basic visualizations with spreadsheets (Part 2 of 3)
Create a Google spreadsheet in your PADJO2015 folder named: PADJO2015-SFCRIME-PIVOTS
It should include 3 different histograms:
Download the CSV data and import into Google spreadsheets
It doesn’t matter how many spreadsheets or pivot tables you use, though obviously you’ll need at least one spreadsheet (of the CSV) and a pivot table.
Obviously, the tutorial on pivot tables and earthquakes will be very handy.
Download the data for this exercise here.
A walkthrough of managing earthquake data and doing basic visualizations with spreadsheets (Part 2 of 3)
A walkthrough of using Pivot Tables to summarize earthquake data across two dimensions, allowing for even more insightful histograms (Part 3 of 3)
Pivot tables are an effective tool for quickly summarizing the facts from a mass of records