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

 Lordandmaker 10-31-2005 09: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 09: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 09: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 09: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 02:10 AM.