US Historical Climate: Excel Statistical
https://serc.carleton.edu/introgeo/mathstatmodels/examples/XLstats.html

R.M. MacKay, SERC Starting Point

This resource is no longer officially part of our collection This resource has been removed from our collection, likely because the original resource is no longer available. If you have further information about the link (e.g. a new location where the information can be found) please let us know.

You may be able to find previous versions at the Internet Archive.

In this intermediate Excel activity, students import US Historical Climate Network mean temperature data into Excel from a station of their choice. They are then guided through the activity on how to use Excel for statistical calculations, graphing, and linear trend estimates. The activity assumes some familiarity with Excel and graphing in Excel.

Subject: Environmental Science:Global Change and Climate
Resource Type: Activities
Grade Level: College Lower (13-14), High School (9-12)
Theme: Teach the Earth:Enhancing your Teaching:NGSS, Teach the Earth:Course Topics:Environmental Science, Teach the Earth:Incorporating Societal Issues:Climate Change