OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Multiple Regression in OpenOffice

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Economist
General User
General User


Joined: 28 Feb 2003
Posts: 10

PostPosted: Fri Feb 28, 2003 7:01 pm    Post subject: Multiple Regression in OpenOffice Reply with quote

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.... Smile
Back to top
View user's profile Send private message
Benno
General User
General User


Joined: 23 Jan 2003
Posts: 6
Location: Copenhagen, Denmark

PostPosted: Sat Mar 01, 2003 4:37 am    Post subject: Me too... Reply with quote

That would ībe a great little exercise for my litte intro-course in StarOffice
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Sun Mar 02, 2003 1:53 am    Post subject: Reply with quote

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
View user's profile Send private message
Economist
General User
General User


Joined: 28 Feb 2003
Posts: 10

PostPosted: Sun Mar 02, 2003 2:57 am    Post subject: Reply with quote

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
View user's profile Send private message
LiamC
Guest





PostPosted: Mon Feb 16, 2004 2:33 pm    Post subject: Radom/fixed effects Reply with quote

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
Super User


Joined: 09 Sep 2003
Posts: 3211
Location: Troyes France

PostPosted: Mon Feb 16, 2004 9:23 pm    Post subject: Reply with quote

I have post a text iwith a macro to show how to use linest ...
See Least Squares fitting here : http://ooomacros.org/user.php#104423
The problem with linest is that its name let you believe you can only estimate a line. But this is false. See the text for more explanations.
_________________
Linux & Windows OOo3.0
UNO & C++ : WIKI
http://wiki.services.openoffice.org/wiki/Using_Cpp_with_the_OOo_SDK
In French
http://wiki.services.openoffice.org/wiki/Documentation/FR/Cpp_Guide
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group