A classroom/ laboratory activity titled, ‘US Historical Climate: Excel Statistical’ from Starting Point by R.M. MacKay, Clark College, USA, to calculate mean, variance, standard deviation, maximum, minimum, and trends estimates for historical temperature data.
This data is provided in an Excel spreadsheet in the activity. It also includes a PDF document with detailed instructions. It further includes questions that you may wish to use in your classroom to explain statistical functions and methods and to initiate a discussion on the increase in average and mean temperature anomalies from 1895 to 1994.
Students will learn to use Excel for statistical calculations such as average, mean, variance and standard deviation. They will also learn the use of running mean filter and how to calculate statistical errors in a given data.
Use this tool to help your students find answers to:
- Define the following:
- Standard Deviation
- Variance
- Running Mean
- Statistical Error
- How do the anomaly variance and standard deviations compare with the temperature variance and standard deviation?
- Knowing that Winter solstice is December 21, what is the lag in months between minimum solar input and minimum temperature?
About the Tool
Tool Name | US Historical Climate: Excel Statistical |
Discipline | Mathematic and Statistics |
Topic(s) in Discipline | Excel Functions, Statistical Functions, Mean, Variance, Standard Deviation, Statistical errors, Running Mean |
Climate Topic | Climate and the Atmosphere, Climate Variability Record |
Type of tool | Classroom/Laboratory Activity |
Grade Level | High School, Undergraduate |
Location | Global |
Language | English |
Translation | |
Developed by | R.M. MacKay |
Hosted at | Starting Point: Teaching Entry Level Geoscience |
Link | Link |
Access | Online, Offline |
Computer Skills | Basic |