Earthquakes

earthquakes

Go to this web site:

  1. Welcome to the U.S. Geological Survey Earthquake Hazards Program Earthquakes Products / Data

    1. click on ANSS Comprehensive Earthquake Catalog (ComCat) - Parametric Data

  2. Change date to: 2010-11-05 00:00:00

  3. Change Magnitude to Min: 5

  4. Change format to CSV (comma-separated values)

  5. Press Search

  6. Your file will be names Query.csv

  7. Open it with Excel

  8. Delete Column A

  9. Delete Columns D-O

  10. switch column A + B

  11. Select data

  1. Turn into scatter graph

  2. What do you see?

Google sheets data set. Make a copy and rename

Data w/scatter graph

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