Usually it is done thanks to linear least squares regression :
Least Squares Fitting -- from Wolfram MathWorld
Hi, I hope that this is the correct category for this post. I am new here, so please bear with me.
Anyways here is my question
I am doing a math project where I need to use a function to model data.
The data is this:
X: Y:
0 197
4 203
8
12
16 198
20 204
24 212
28 216
32 218
36 224
40 223
44 225
48 236
Note there is not data for x=8,12. Anyways, I need to show the calculations for the LINEAR line of best fit. Using programs like excel, I have found the equation of this line to be y=0.7551x+194.14
But when I try to calculate it by hand, the closest I can come to is y=0.75x+200.
I do this by finding slope from point (32,218) and (24,212), which is .75 and then i sub that in to find the y-intercept. I don't really now how I am supposed to end up with 0.7551x+194.14 though. But I need to show that calculation to get full marks. Does anyone know how to do this and if they do, could they write it out for me.
Thanks so much
Usually it is done thanks to linear least squares regression :
Least Squares Fitting -- from Wolfram MathWorld