LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   how do I display a Linear regression formula using Open Office? (http://www.linuxquestions.org/questions/linux-software-2/how-do-i-display-a-linear-regression-formula-using-open-office-345169/)

izquierdista 07-20-2005 07:42 PM

how do I display a Linear regression formula using Open Office?
 
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 07:46 PM

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

izquierdista 07-20-2005 07: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


All times are GMT -5. The time now is 04:47 AM.