how do I display a Linear regression formula using Open Office?

izquierdista · 07-20-2005, 06:42 PM

Hello,
I am using openoffice's spreadsheet program to generate a graph. I have already made a graph and inserted the linear regression line. What I would like to know is how do I display the formula for the linear regression line?

Can someone tell my how to do this.

tuxdev · 07-20-2005, 06:46 PM

Insert->Object->OLE Object->OpenOffice.org Formula
Edit the formula to your needs

izquierdista · 07-20-2005, 06:51 PM

I saw on a website that I could use the formula Linest() which is one of the functions I can access by clicking on the function autopilot button.

Can you tell me what parameter to put in, for the following data:

Current (A)
0.001078
0.00245
0.004116
0.005648
0.00735
0.00882
0.010584
0.012054
0.013524
0.015092

Force (N)
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5

The current is the in the X axis and the Force is in the Y axis