LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 07-20-2005, 06:42 PM   #1
izquierdista
Member
 
Registered: Mar 2005
Distribution: Ubuntu
Posts: 342

Rep: Reputation: 30
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.

Last edited by izquierdista; 07-20-2005 at 06:46 PM.
 
Old 07-20-2005, 06:46 PM   #2
tuxdev
Senior Member
 
Registered: Jul 2005
Distribution: Slackware
Posts: 2,012

Rep: Reputation: 111Reputation: 111
Insert->Object->OLE Object->OpenOffice.org Formula
Edit the formula to your needs
 
Old 07-20-2005, 06:51 PM   #3
izquierdista
Member
 
Registered: Mar 2005
Distribution: Ubuntu
Posts: 342

Original Poster
Rep: Reputation: 30
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

Last edited by izquierdista; 07-20-2005 at 06:52 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regression lines on graphs in in Open Office? Lordandmaker General 3 10-31-2005 09:45 AM
elapsed time formula for open office calc philosophe Linux - Software 1 03-30-2005 05:32 AM
How to Get Open Office 2.0beta to Mimic MS Office 2003 Look? mac57 Linux - Software 2 03-08-2005 07:02 AM
Linear Regression Hjalte Linux - Software 1 11-18-2004 09:33 AM
Star office / Open Office on Sony Picturebook kkempter Linux - Laptop and Netbook 4 12-11-2003 01:34 PM


All times are GMT -5. The time now is 09:02 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration