In article <[email protected]>, Brian Barker <[email protected]> wrote:
> At 15:13 01/07/2009 -0400, Robert Peirce wrote: > >I use this in Excel all the time, especially for plotting regression > >analysis. Is there some way to get it in Calc? I can't find it. > > o Are the RSQ() and LINEST() functions relevant? > > Also: > o Double-click a chart (so you see the grey outline, not the eight > green handles). > o Right-click on a data point and select Insert Trend Line... . > o On the Type tab, under Equation, tick "Show equation" or "Show > correlation coefficient (R^2)" as required. > > I trust this helps. Not really. In Excel I can select data analysis, which is an add-in, and get all the regression data along with a chart, with a couple of clicks. It is now about the only reason I still use Excel. I would like to find something comparable in Calc. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
