This is an Excel activity for students that has them compute the standard deviation and determine which cities have the most consistent temperatures. There is a worksheet for Missouri, New York, and South Carolina. Each worksheet has three major cities and the average monthly temperature. There is also a completed project so that you can compare the formulas used. In the Missouri worksheet, students find standard deviation by using sums, and taking the square root of the variance. In the subsequent worksheets, they explore the built in formulas Excel offers.
Detailed instructions for the activity appear on each worksheet. However, students do need to know how to input a formula, and some of the basic formulas of Excel, such as sqrt.
The previews show an uncompleted project and the completed project.