[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

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....
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
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.
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!
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.)
SergeM
Super User

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

 Posted: Mon Feb 16, 2004 9:23 pm    Post subject: 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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