Home Forums HCL Reviews Tutorials Articles Register Search Today's Posts Mark Forums Read
 LinuxQuestions.org Regression lines on graphs in in Open Office?
 General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

 10-31-2005, 09:25 AM #1 Lordandmaker Member   Registered: Sep 2005 Location: London, UK Distribution: Debian Posts: 258 Rep: 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?
 10-31-2005, 09:29 AM #2 vharishankar Senior Member   Registered: Dec 2003 Posts: 3,161 Blog Entries: 4 Rep: 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.
 10-31-2005, 09:41 AM #3 Lordandmaker Member   Registered: Sep 2005 Location: London, UK Distribution: Debian Posts: 258 Original Poster Rep: 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!
 10-31-2005, 09:45 AM #4 vharishankar Senior Member   Registered: Dec 2003 Posts: 3,161 Blog Entries: 4 Rep: 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.

 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 Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post viniosity Linux - Software 3 05-21-2006 06:44 AM izquierdista Linux - Software 2 07-20-2005 06:51 PM mac57 Linux - Software 2 03-08-2005 07:02 AM btexpress Linux - Software 2 05-17-2004 12:26 PM kkempter Linux - Laptop and Netbook 4 12-11-2003 01:34 PM

LinuxQuestions.org

All times are GMT -5. The time now is 04:54 PM.

 Contact Us - Advertising Info - Rules - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -