LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   General (http://www.linuxquestions.org/questions/general-10/)
-   -   Regression lines on graphs in in Open Office? (http://www.linuxquestions.org/questions/general-10/regression-lines-on-graphs-in-in-open-office-378619/)

Lordandmaker 10-31-2005 10:25 AM

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?

vharishankar 10-31-2005 10:29 AM

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.

Lordandmaker 10-31-2005 10:41 AM

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!

vharishankar 10-31-2005 10:45 AM

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.


All times are GMT -5. The time now is 01:13 AM.