This lesson introduces simple linear regression with several Excel spreadsheet examples such as temperature versus cricket chirps, height versus shoe size, and laziness versus amount of TV watched. These activities require class participation.
This online calculator allows users to enter 16 observations with up to 4 dependent variables and calculates the regression equation, the fitted values, R-Squared, the F-Statistic, mean, variance, first order serial-correlation, second order serial-correlation, the Durbin-Watson statistic, and the mean absolute errors. It also tests normality and gives the i-th residuals.