You can
put this solution on YOUR website!From your graph, you have 9 (x,y) data pairs.
First, make a table with the x,y data points.
Add 5 columns to your table.
1.
2.
3.
4.
5.
6.
7.
where
is the average of the x values and
is the vaverage of the y values.
Calculate the values for i=1 to 9.
Sum columns 5,6,7.
You are solving for the regression equation
where
or
and
From this we see that
is the slope of the regression line.
is the y-intercept of the regression line.
is the equation of the regression line.
To calculate the
, you need to calculate two more quanitities,
and
where
or
and
or
and
N is the number of data points, 9.
The coefficient,
, is then calculated from
EXCEL is the perfect program to do this kind of work.
Good luck.
Post another question if you get stuck.
