This is a series of interactive excel sheets exploring linear regression.
The first sheet plots a scatter diagram and line of best fit for a small set of bivariate data. The mean and product moment correlation coefficient is also calculated.
The second sheets displays a summary of the formulae used to calculate the coefficients, a and b, in the regression line y= ax +b.
The following sheet produces a series of data sets (with eight to twelve variables in each) from which the equation of the regression line can be calculated. The answers can be revealed step by step by the click of a button, and a scatter graph for the data can be seen by clicking the “Graph” button.
The next sheet provides six examples from which students can find the equation of the regression lines. The answers can be revealed, and a new set of questions created each time. The original data and scatter graph for each question can be shown by clicking each question number.
This program was designed by be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on users’ machine.