trend line / line of best fit OO.org

mrxoliver · 11-14-2006, 01:54 PM

Just wondered if anyone knows an easy way of putting a line of best fit into calc (eg. http://www.bbc.co.uk/schools/gcsebit.../ma03024_2.gif) like you can in excel or if anyone has written a macro to do this, otherwise I'll suggest this to the OO team.

Thanks

bigrigdriver · 11-15-2006, 03:19 PM

If you want to show a trend, as a prediction of future values from present and past known values, use the trend() function.

If you want a best-fit line ala least-squares, use the linest() function.

You can get more info from the OpenOffice.org Calc Help manual.

I found this in re linest: http://justlinux.com/forum/archive/i.../t-145367.html

And this site has OpenOffice.org macros, two of which refer to least-squares fitting: http://sourceforge.net/project/showf...group_id=87718

bigalexe · 11-15-2006, 03:21 PM

i normally use a graphing calc to do those kinds of things however ive never done it on PC