LAB: Using Temperature and Salinity Data for an Excel exercise

Posted on by
Purpose:
To transfer Environmental Data being recorded at Race Rocks from a spread sheet presented on the internet to your own computer in order to be able to graph trends and analyze relationships.
Background:
Long term data bases are very important for a number of reasons. You may wish to write down in your assignment notes some of the applications you could use for such data. Certainly patterns of cyclic activity and even events such as Climate Change can be detected from the Race Rocks Data. Try to come up with a few other applications. We intend to make a complete range of environmental data from data sensors as these get installed.See this file for the Data Recording IndexSee also IDEAS FOR STATISTCS ASSIGNMENTS
USING EXCEL DATA FROM racerocks.com 

RACE ROCKS TEMPERATURE AND SALINITY EXERCISE
Since 1921 the Light keepers at Race Rocks have recorded some basic climatic data at Race Rocks. They started by taking daily sea water temperatures and in 1936 added daily salinity measurements to their measurements. The record is fairly complete except for a few years during the second world war, and so far we have not been able to determine why those records were not kept at that time. 1.This is a file with the daily sea temperatures and salinity and atmospheric data since the year 2000, as recorded by Mike Slater:2. We were able to get this complete monthly mean data base for Temperature….1921->present and this complete monthly mean data base…1936-present for Salinity from the Institute of Ocean Sciences.

3. Copy and Paste the data for the years you want to analyse from the web page directly into your blank EXCEL workbook.

4. You now have our original data on your computer and you can proceed to do any one of the many manipulations possible in the EXCEL program. You can also copy and paste in other month’s data in order to get a larger data set .

5. Take the opportunity to creative in the way you look at and interpret data, we would be interested in attaching your findings to this website. Send comments to: Garry Fletcher Just e-mail your analysis as an attachment.

6. You are welcome to use this data for educational purposes, you are just asked to reference the source as:
Lester B. Pearson College, racerocks.com

See this file for other ideas on Statistics from racerocks.com data.