| View previous topic :: View next topic |
| Author |
Message |
Economist
General User
Joined: 28 Feb 2003
Posts: 10
|
 Posted: Fri Feb 28, 2003 7:01 pm Post subject: Multiple Regression in OpenOffice |
 |
|
I know that I can run a simple linear regression using the slope and intercept functions. But...
Is it possible to run a multiple regression in openoffice? In both excel and gnumeric it is possible to run a basic multiple regression. The results then appear in a fresh worksheet which I can then paste back the coefficients etc into my main calculation spreadsheets. It is a very useful function....  |
|
| Back to top |
|
 |
Benno
General User
Joined: 23 Jan 2003
Posts: 6
Location: Copenhagen, Denmark
|
| Posted: Sat Mar 01, 2003 4:37 am Post subject: Me too... |
|
|
| That would ībe a great little exercise for my litte intro-course in StarOffice |
|
| Back to top |
|
|
ftack
Moderator
Joined: 27 Jan 2003
Posts: 3102
Location: Belgium
|
| Posted: Sun Mar 02, 2003 1:53 am Post subject: |
|
|
The 'basic'way of doing linear regression is by using the LINEST function, which works pretty much the same as in MS Excell. You can perform multiple regression here by specifying a matrix of X-values (i.e. multiple columns), for example =LINEST(C2:C5;A2:B5;1;1)
The "Autopilot" function will help you with this function and automatically enter it as an array function.
Another, more wizard-like way of doing a multiple regression that includes a more 'fancy' report, is currently not available in OOo. |
|
| Back to top |
|
|
Economist
General User
Joined: 28 Feb 2003
Posts: 10
|
| Posted: Sun Mar 02, 2003 2:57 am Post subject: |
|
|
| I wasn't aware of that formula. That's even better, as it calculates automatically when I update my data. Thanks for that! |
|
| Back to top |
|
|
LiamC
Guest
|
| Posted: Mon Feb 16, 2004 2:33 pm Post subject: Radom/fixed effects |
|
|
| That is great for doing pooled results in a multiple regression. But is there a way to do Random/fixed effects for a multiple regression (this is something that excel can't do.) |
|
| Back to top |
|
|
SergeM
Super User
Joined: 09 Sep 2003
Posts: 3211
Location: Troyes France
|
|
| Back to top |
|
|
|
