Earthquakes
earthquakes
Go to this web site:
Welcome to the U.S. Geological Survey Earthquake Hazards Program Earthquakes Products / Data
click on ANSS Comprehensive Earthquake Catalog (ComCat) - Parametric Data
Change date to: 2010-11-05 00:00:00
Change Magnitude to Min: 5
Change format to CSV (comma-separated values)
Press Search
Your file will be names Query.csv
Open it with Excel
Delete Column A
Delete Columns D-O
switch column A + B
Select data
Turn into scatter graph
What do you see?
Google sheets data set. Make a copy and rename
Note:
If you get all of the data in column 1, follow these instructions to covert to columns
Paste into Excel in column A
Click on column A and then under Data...choose text to columns
Select delimited
Select Comma under Delimiters
Click next ... do nothing
Click Finish