LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

Reply
 
Search this Thread
Old 10-31-2005, 09:25 AM   #1
Lordandmaker
Member
 
Registered: Sep 2005
Location: London, UK
Distribution: Debian
Posts: 258

Rep: Reputation: 38
Regression lines on graphs in in Open Office?


Morning!

Got a quick bit of homework from uni which requires me to generate a graph with a regression line on it in Excel, though i don't have excel.

I can't find anything in OO.o spreadsheet to draw a regression line on the graph. Any ideas?
 
Old 10-31-2005, 09:29 AM   #2
vharishankar
Senior Member
 
Registered: Dec 2003
Posts: 3,142
Blog Entries: 4

Rep: Reputation: 121Reputation: 121
Regression lines are nothing but straight line equations...

One way is to generate the values for the regression equation (which is a straight line as you should know) and then use the graph feature to draw a line graph based on the data.

This should be fairly simple? I'm afraid that it's difficult to explain, but it's rather easy to achieve.

Last edited by vharishankar; 10-31-2005 at 09:32 AM.
 
Old 10-31-2005, 09:41 AM   #3
Lordandmaker
Member
 
Registered: Sep 2005
Location: London, UK
Distribution: Debian
Posts: 258

Original Poster
Rep: Reputation: 38
Yeah, i know what you mean.

Lecturer hinted that in excel it's in a right-click menu, so i was hoping for this.

Cheers!
 
Old 10-31-2005, 09:45 AM   #4
vharishankar
Senior Member
 
Registered: Dec 2003
Posts: 3,142
Blog Entries: 4

Rep: Reputation: 121Reputation: 121
Use the formula feature (I'm sure you know the "=" thing). Generate the set of X values and then compute the Y values for each X and then plot the graph...

It depends on whether it's Y on X or X on Y. So you'll need two sets of values. One for the X on Y and the other for the Y on X.
 
  


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
Star Office vs. Open Office installation Q viniosity Linux - Software 3 05-21-2006 06:44 AM
how do I display a Linear regression formula using Open Office? izquierdista Linux - Software 2 07-20-2005 06:51 PM
How to Get Open Office 2.0beta to Mimic MS Office 2003 Look? mac57 Linux - Software 2 03-08-2005 07:02 AM
Open Office docs for Microsoft Office btexpress Linux - Software 2 05-17-2004 12:26 PM
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 12:34 PM.

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