Regression (Linear)

Rate this resource

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.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Show downloads

Published by


Share this resource