Support LQ: Use code LQ3 and save \$3 on Domain Registration
 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, 10: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, 10:29 AM #2 vharishankar Senior Member   Registered: Dec 2003 Posts: 3,142 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 10:32 AM.
 10-31-2005, 10: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, 10:45 AM #4 vharishankar Senior Member   Registered: Dec 2003 Posts: 3,142 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.