Math Luvr

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 s

This activity was created to help introduce students to normal data distributions. This file contains an Excel workbook with instructions (for both 2010 and 2013 versions of Excel) for students to do the following: Find the Mean, standard deviation, median, mode, and the distribution of data within a certain number of standard deviations from the mean. Create bar graph and line chart of frequencies. Answer questions regarding data on separate Worksheet. This activity is totally editable, so you

If you are teaching stats and incorporating spreadsheets, this might fit the bill for a fun activity for Halloween. The plus is it does have some educational value, as well as a fun Mystery Image sheet, as well. Students go to a website and read statistical information, then they create line graphs and answer questions in the first spreadsheet. In the second, they are just practicing their spreadsheet formatting skills by following step-by-step instructions to create an image. There are two

This activity has students read an online article with current statistics related to Halloween, then make line graphs and answer questions on a Google sheet. The second sheet is a mystery image that appears after you apply the step-by-step formatting instructions. It has a little real math and a little fun, so I use it for Halloween in my statistics classes. The pictures are from my Excel version, but they are very similar. The main difference is that I have fun pictures in this version. To