Activity 1 - DO and Temp Correlation


In this activity you will be examining the relationship between the variables DO and temperature on a summer day in the hypolimnion of Seneca Lake. You will graph the data provided and look for a correlation between the two variables. Correlation is measured between +1.0 and -1.0. As the number gets closer to zero the weaker the correlation. Correlations close to +1.0 indicate a strong positive relationship, whereas correlations close to -1.0 indicates a strong negative relationship. An example of a positive correlation would be sun exposure and sunburn - the more sun exposure a person has the more likely that person will get sunburn. An example of a negative correlation would be speed and time. The greater the speed a car drives the shorter the time it takes to get to the destination. Before conducting this activity review how graphing correlations work by visiting the following website: Graphing Correlations.


To conduct this activity you will need to follow these steps:

1) Link to the Seneca Lake DO/Temp data set.

Activity for Users of Excel Before 2007

Activity for Users of Excel Version 2007

19) Answer the following questions:

A. Is there a strong correlation between DO levels and Temp for Seneca Lake? Is it positive or negative?

B. The data for DO and Temp were taken at depths below 29 M - the hypolimnion - would you expect photosynthesis to contribute to DO levels at these depths?

C. What can you infer from this graph about the DO levels in the hypolimnion of Seneca Lake?


Preparing Students to Lead Lives of Consequence.