US Historical Climate: Excel Statistical

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.

Go To:

R.M. MacKay
SERC Starting Point
Activity will take about two hours depending on the familiarity with Excel.

Notes From Our Reviewers

The CLEAN collection is hand-picked and rigorously reviewed for scientific accuracy and classroom effectiveness. Read what our review team had to say about this resource below or learn more about how CLEAN reviews teaching materials

Teaching Tips

Teaching Tips

Very extensive Excel instructions and good links for further reading/help.

Getting current data from the interface is fast and responsive for getting data plots.

All required materials are downloadable from site.

Share This: