I need to plot the Least Squares Regression Line (not just calculate its values with the LINEST function). Can anyone advise me on how to graph this line?
Numbers-OTHER, OS X Mountain Lion (10.8.1)
t,
Your Mac OS includes an app called Grapher that is the best way to plot expressions, assuming that you have a proper expression to plot.
Jerry
If you want to graph in Numbers AND you know the slope (m) and offset (b) then you can pick two points (at the extreme of the range of X) and compute the corresponding Y. Then graph on an X-Y scatter cahrt where the connect dots setting is enabled.
Grapher.app in OS X Utilities is excellent for that : entering data from Numbers Excel etc. into a Grapher "Point Set", plotting all your data, computing and plotting a regression curve linear or exponential or polynomial.
Unfortunately there is not a single word about point sets and regression in the Grapher Help.
So, suggest you download (free) "Instruction for Use - Grapher on web site
http://y.barois.free.fr/grapher/Documentation.html
and go to page 31 to 37, "Initiation > Lesson 6 : Treating a point set (Regression curve), and also page 68, "Appendix 1. Points sets : from speadsheets to Grapher".
If you try Grapher's regression curves, please tell us about the manual above : useful or not, too easy or difficult, readable or not etc.
Thank you.
YB24
PS. Documentation about Grapher is also here : Google "Apple Grapher" > http://en.wikipedia.org/wiki/Grapher > Article > Talk > Grapher 1.1 to 2.3 (French and English) (11th september 2012)
I need to plot the Least Squares Regression Line (not just calculate it with the LINEST function). How?
