Linear regression and modelling problems are presented along with their solutions at the bottom of the page. Also a linear regression calculator and grapher may be used to check answers and create more opportunities for practice.
Review
If the plot of n pairs of data (x , y) for an experiment appear to indicate a "linear relationship" between y and x, then the method of least squares may be used to write a linear relationship between x and y.
The least squares regression line is the line that minimizes the sum of the squares (d1 + d2 + d3 + d4) of the vertical deviation from each data point to the line (see figure below as an example of 4 points). The least square regression line for the set of n data points is given by the equation of a line in slope intercept form:
y = a x + b
where a and b are given by
Problem 1
Problem 2
Problem 3
The values of y and their corresponding values of y are shown in the table below
Problem 4
The sales of a company (in million dollars) for each year are shown in the table below.
x (year) | 2005 | 2006 | 2007 | 2008 | 2009 |
y (sales) | 12 | 19 | 29 | 37 | 45 |
Solutions to the Above Problems
- a) Let us organize the data in a table.
x | y | x y | x 2 |
-2 | -1 | 2 | 4 |
1 | 1 | 1 | 1 |
3 | 2 | 6 | 9 |
?x = 2 | ?y = 2 | ?xy = 9 | ?x 2 = 14 |
We now use the above formula to calculate a and b as follows
a = (n?x y - ?x?y) / (n?x 2 - (?x) 2 ) = (3*9 - 2*2) / (3*14 - 2 2 ) = 23/38
b = (1/n)(?y - a ?x) = (1/3)(2 - (23/38)*2) = 5/19
b) We now graph the regression line given by y = a x + b and the given points.
a) We use a table as follows
x | y | x y | x 2 |
-1 | 0 | 0 | 1 |
0 | 2 | 0 | 0 |
1 | 4 | 4 | 1 |
2 | 5 | 10 | 4 |
?x = 2 | ?y = 11 | ?x y = 14 | ?x 2 = 6 |
We now use the above formula to calculate a and b as follows
a = (n?x y - ?x?y) / (n?x 2 - (?x) 2 ) = (4*14 - 2*11) / (4*6 - 2 2 ) = 17/10 = 1.7
b = (1/n)(?y - a ?x) = (1/4)(11 - 1.7*2) = 1.9
b) We now graph the regression line given by y = ax + b and the given points.
a) We use a table to calculate a and b.
x | y | x y | x 2 |
0 | 2 | 0 | 0 |
1 | 3 | 3 | 1 |
2 | 5 | 10 | 4 |
3 | 4 | 12 | 9 |
4 | 6 | 24 | 16 |
?x = 10 | ?y = 20 | ?x y = 49 | ?x 2 = 30 |
t (years after 2005) | 0 | 1 | 2 | 3 | 4 |
y (sales) | 12 | 19 | 29 | 37 | 45 |
We now use the table to calculate a and b included in the least regression line formula.
t | y | t y | t 2 |
0 | 12 | 0 | 0 |
1 | 19 | 19 | 1 |
2 | 29 | 58 | 4 |
3 | 37 | 111 | 9 |
4 | 45 | 180 | 16 |
?x = 10 | ?y = 142 | ?xy = 368 | ?x 2 = 30 |
More References and links
- Linear Regression Calculator and Grapher.
- Linear Least Squares Fitting.
- elementary statistics and probabilities.