In: Advanced Math
Find the line y = b + mx of best fit through the data {(.1, .2),(.2, .3),(.3, .7),(.5, .2),(.75, .8)}, using the least squares criterion.
(Use one of the software tools: Excel, SPSS, Mathematica, or MATLAB to answer the following items, and print out your results directly from the software)
Points are represented as (x,y). The datapoints are :
The points are plotted in excel and the in-built regression function is used to find the equation. The equation is displayed on the chart itself. The dotted line is fitted line.
Manual calculations based on least fit criteria
Both the equations are same.