How does one perform least-squares analysis in Excel? I need a y=mx+b formula for a graph, and although the instructions suggest using Excel, they do not specify how to do this.
Thank you in advance.
2006-10-17 16:42:24 · 3 answers · asked by purplekitten 5 in Computers & Internet ➔ Software
Type in Column A X values, m values in B, b values in C.
Now in D paste this function
= A1 * B1 + C1
So Column D will have the value of Y
copy and paste these values to what you need of points.
now select one of these cells an go to Insert > Chart
And you will figure it out
XLMan
2006-10-18 23:44:36 · answer #1 · answered by Anonymous · 0⤊ 1⤋
What you favor to do is carry out an study utilising Residual Plots. you should use residuals to construct countless plots which 'try' diverse aspects of the form being equipped i.e. the assumptions being made about e's. eg widespread chance plots will tutor any marked deviation from normality. Plots of residuals hostile to equipped values might want to tutor no detectable progression! no longer all relationships between a reaction and a (set of) predictor variables will be linear. notwithstanding acceptable ameliorations can often be stumbled on to reduce a theoretically non-linear form to a linear form. e.g. theoretical courting Y=kX^n is non linear this kind is linearised through taking logs ie logY = logk + nlogX undergo in concepts in case you rework the records be careful about making comments or drawing end about the 'authentic existence' (non-linear) set-up.
2016-10-16 05:23:01 · answer #2 · answered by Anonymous · 0⤊ 0⤋
purple honey try this link
http://www.google.co.uk/search?hl=en&q=Least+squares+analysis+in+Excel&btnG=Search&meta=
2006-10-17 22:45:40 · answer #3 · answered by Joe_Young 6 · 0⤊ 1⤋