This should get you going.
From the HELP file:
DEVSQ
Returns the sum of squares of deviations based on a sample mean.
Syntax
DEVSQ(Number 1; number 2; ...number 30)
*Number 1,number 2,...number 30* numerical values or ranges representing
a sample.
Example
=DEVSQ(A1:A50)
SLOPE
Returns the slope of the linear regression line. The slope is adapted to
the data points set in the y and x values.
Syntax
SLOPE(data_Y; data_X)
*Data_Y* is the array or matrix of Y data.
*Data_X* is the array or matrix of X data.
Example
=SLOPE(A1:A50; B1:B50)
Example
=EXPONDIST(3; 0.5; 1) returns 0.78.
INTERCEPT
Calculates the point at which a line will intersect the y-values by
using known x-values and y-values.
Syntax
INTERCEPT(data_Y; data_X)
*Data_Y* is the dependent set of observations or data.
*Data_X* is the independent set of observations or data.
Names, arrays or references containing numbers must be used here.
Numbers can also be entered directly.
Example
To calculate the intercept, use cells D3:D9 as the y value and C3:C9 as
the x value from the example spreadsheet. Input will be as follows:
INTERCEPT(D3:D9;C3:C9) = 2.15.
octavian rotaru wrote:
Thanks a lot!!! Is there also a way to display the function of the trend
line according to the regression type?
CPHennessy <[EMAIL PROTECTED]> wrote: On Friday 15 December 2006 19:44, +
octavian rotaru wrote:
Hy my name is Octavian and I would like to know if I can add a
trendline and regression function in Open Office 2.1 Calc based on data
sets. Just as a comparison that's how such a task works in MS Excel:
As you are not subscribed you may not have seen that:
On Saturday 16 December 2006 19:35, Joe Conner wrote:
This is available. I use it frequently, with X-Y chart
types. Double Click on the graph, then go to the top menu
INSERT - STATISTICS - Scroll the regression curve selection
to the type of regression you want, and click.
Please reply to [email protected] only.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
