Through this activity students will gain an understanding of the effect of the sample size on experiments and simulations. A Microsoft Excel program file and handouts are provided.
A "12 page" tutorial that explores the liner models via excel spreadsheets. The learning module leads the user through various aspects of linear modeling. This tutorial includes a worksheet that allows students to vary the scatter (or noise) level, by adjusting the scroll bar or by clicking on the arrows, to see how the slope and intercept of line respond to the addition of scatter to the data, while monitoring the value of r^2.