Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.
Regression
These activities cover bivariate data which includes regression and correlation.
[b]Least squares regression[/b] spreadsheet is designed to help students get a feel for drawing a line of best fit through a set of points and to begin to understand the concept of regression. Students are given a set of six coordinates plotted with the line y = a + bx. Students are required to alter the values of a and b to find the best line of fit. Residuals are calculated to help indicate the best fit line. Work card 7.1 support student use of this spreadsheet and poses further challenges.
The next spreadsheet is designed to enable students understand what is meant by the 'goodness of fit' by noting the effects of alterations to the values of r, R-squared and s. Work card 7.2 support student use of this spreadsheet and poses further challenges.
The next spreadsheet helps students understand what a correlation coefficient measures. Students are presented with a set of points and have to predict what the correlation coefficient is before revealing the exact answer. Work card 7.3 support student use of this spreadsheet.
[b]Linear combinations[/b] shows how the standard deviation of linear combinations of variables is calculated. In the first case the variables are independent whereas in the second case the student can determine the correlation. Students are able to alter variables in order to see their effect. Work card 7.4/5 support student use of this spreadsheet and poses further challenges.
The regression calculator performs regression analysis on the students own data. Three plots are given: the data with the line of best fit, the residuals against the fitted values and the normal probability plot of the residuals. Work card 7.6 support student use of this spreadsheet.
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.
Downloads
-
Regression workcards 45 KB
-
Regression workbook 87.5 KB
Show downloads
-
Regression workcards 45 KB -
Regression workbook 87.5 KB
Download all files as a .zip32.74 KB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
