Now lets see if we can do a best fit ourselves, that
is , find the a and b coefficients of the least squares
best fit line y=ax+b. This will give you a much better
understanding of what the calculator is doing
"behind the scenes."
To do the least squares fit by hand you will find that
a five column table greatly simplifies the
calculation. The first two columns are the x and y values
that are given in the original problem
(the scatter plot points). The next column (column 3)
is the x values squared, column 4 is x and
y multiplied together, and the last column, column 5,
is the y values squared. You will see in a minute
how we use these but for now just make this table. When finished, take the sum of each
column
and also find the mean of the x and y's (column 1 and
2). Be careful not to round, the least
squares calculation is very sensitive to rounding errors.
Here is the finished table.