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

HELP... Trying (So Far Unsuccesfully) to Employ "Pop To

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
9281selfconsciousseleucid
Newbie
Newbie


Joined: 16 Sep 2007
Posts: 1

PostPosted: Sun Sep 16, 2007 8:15 pm    Post subject: HELP... Trying (So Far Unsuccesfully) to Employ "Pop To Reply with quote

:?: I just installed/downloaded OOo 2.2 Pro into my PC-- with the specific interest in making use of "Pop Tools" http://www.cse.csiro.au/poptools/ statistical software with the Excel component --- the vendor who sold me this OO product said it would "work seamlessly" in such applications (for Excel.) The application of "Pop Tools" is freeware for 'resampling procedures' (like 'the bootstrap,' 'the jackknife,' and 'Monte-Carlo-simulation'); as such I don't think there are many if any proprietary reservations vis a vis GIVING ME ADVICE on this point of juncture.

Specifically, I can't "get" what the "Pop Tools" people say I should have with the "Excel-like" spreadsheet such as you have; one is supposed to get a POP TOOLS TOOLBAR-- which does not appear on my Calc page. Am I missing something here?

NEED INPUT KEENLY: WANT TO GET USE OF 'THE BOOTSTRAP,' ETC. WITH CALC IN A MOST-KEEN WAY!!! ANY/ALL GOOD ADVICE IS HIGHLY DESIRABLE: SI VOUS PLAIT!!!!

--Vernon Lynn Stephens, M.S.S.W.
12a EDST USA -- Monday, 9/17/2007
_________________
E-Mail: freethink@bellsouth.net

Mailing Address:
Agonia
743 East Broadway
Suite # 155
Louisville, Kentucky
40202-1711 (USA)
Back to top
View user's profile Send private message Send e-mail
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Sep 17, 2007 2:16 am    Post subject: Reply with quote

Same answer as in http://www.oooforum.org/forum/viewtopic.phtml?p=249021#249021
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Mon Sep 17, 2007 3:12 am    Post subject: Re: HELP... Trying (So Far Unsuccesfully) to Employ "Po Reply with quote

9281selfconsciousseleucid wrote:
Question I just installed/downloaded OOo 2.2 Pro into my PC-- with the specific interest in making use of "Pop Tools" http://www.cse.csiro.au/poptools/ statistical software with the Excel component --- the vendor who sold me this OO product said it would "work seamlessly" in such applications (for Excel.) The application of "Pop Tools" is freeware for 'resampling procedures' (like 'the bootstrap,' 'the jackknife,' and 'Monte-Carlo-simulation'); as such I don't think there are many if any proprietary reservations vis a vis GIVING ME ADVICE on this point of juncture.

Specifically, I can't "get" what the "Pop Tools" people say I should have with the "Excel-like" spreadsheet such as you have; one is supposed to get a POP TOOLS TOOLBAR-- which does not appear on my Calc page. Am I missing something here?

NEED INPUT KEENLY: WANT TO GET USE OF 'THE BOOTSTRAP,' ETC. WITH CALC IN A MOST-KEEN WAY!!! ANY/ALL GOOD ADVICE IS HIGHLY DESIRABLE: SI VOUS PLAIT!!!!

--Vernon Lynn Stephens, M.S.S.W.
12a EDST USA -- Monday, 9/17/2007


It' extremely unlikely that it will work with OOo Calc. Calc is roughly equivalent to Excel in functionality but it is not a clone. You might want to look at some stats packages. It is generally better to use a stats package rather than a spreadsheet for statistics.


Some sites for some dedictated statistiscs/graphing packages (Free or shareware in most or all cases)

http://gsociology.icaap.org/methods/soft.html
http://freestatistics.altervista.org/stat.php
http://www.psychnet-uk.com/experimental_design/software_packages.htm
http://data.fas.harvard.edu/micah_altman/socsci.shtml

There also is a Calc Stats add-on but I don't know if it does anything like what you want to do.

Calc Add-on for Calc
http://www.ooomacros.org/user.php
OOo Statistics
Author: David Hitchcock
This is a suite of macros to perform basic statistical analysis within OpenOffice. These macros give OpenOffice Calc the functionality which Analysis ToolPak gives Microsoft Excel, and many of these routines are unavailable in Excel.
OOoStat routines are dialog-driven and can be installed in their own menu.
There are three modules of user-called macros:
* Basic Statistics: 1-way ANOVA, Kruskall-Wallis test, t-test, 2-way ANOVA, chi-square contingency table test, Wilcoxon sign-rank test, Correlation, Rank Correlation, Simple Regression, Multiple Regression.
* Multivariate Statistics: Principal Components Analysis, Correspondence Analysis, Multidimensional Scaling, MANOVA, Canonical Discriminant Analysis.
* Applications: Histogram, Text-to-Columns, Latin Square generation, Patterned data
These files are released under the GNU General Public License (GPL)
Latest release: Version 0.4 (February 11, 2005)
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Mon Sep 17, 2007 3:15 am    Post subject: Re: HELP... Trying (So Far Unsuccesfully) to Employ "Po Reply with quote

9281selfconsciousseleucid wrote:
Question I just installed/downloaded OOo 2.2 Pro into my PC-- with the specific interest in making use of "Pop Tools" http://www.cse.csiro.au/poptools/ statistical software with the Excel component --- the vendor who sold me this OO product said it would "work seamlessly" in such applications (for Excel.) The application of "Pop Tools" is freeware for 'resampling procedures' (like 'the bootstrap,' 'the jackknife,' and 'Monte-Carlo-simulation'); as such I don't think there are many if any proprietary reservations vis a vis GIVING ME ADVICE on this point of juncture.

Specifically, I can't "get" what the "Pop Tools" people say I should have with the "Excel-like" spreadsheet such as you have; one is supposed to get a POP TOOLS TOOLBAR-- which does not appear on my Calc page. Am I missing something here?

NEED INPUT KEENLY: WANT TO GET USE OF 'THE BOOTSTRAP,' ETC. WITH CALC IN A MOST-KEEN WAY!!! ANY/ALL GOOD ADVICE IS HIGHLY DESIRABLE: SI VOUS PLAIT!!!!

--Vernon Lynn Stephens, M.S.S.W.
12a EDST USA -- Monday, 9/17/2007


It' extremely unlikely that it will work with OOo Calc. Calc is roughly equivalent to Excel in functionality but it is not a clone. You might want to look at some stats packages. It is generally better to use a stats package rather than a spreadsheet for statistics.


Some sites for some dedictated statistiscs/graphing packages (Free or shareware in most or all cases)

http://gsociology.icaap.org/methods/soft.html
http://freestatistics.altervista.org/stat.php
http://www.psychnet-uk.com/experimental_design/software_packages.htm
http://data.fas.harvard.edu/micah_altman/socsci.shtml

There also is a Calc Stats add-on but I don't know if it does anything like what you want to do.

Calc Add-on for Calc
http://www.ooomacros.org/user.php
OOo Statistics
Author: David Hitchcock
This is a suite of macros to perform basic statistical analysis within OpenOffice. These macros give OpenOffice Calc the functionality which Analysis ToolPak gives Microsoft Excel, and many of these routines are unavailable in Excel.
OOoStat routines are dialog-driven and can be installed in their own menu.
There are three modules of user-called macros:
* Basic Statistics: 1-way ANOVA, Kruskall-Wallis test, t-test, 2-way ANOVA, chi-square contingency table test, Wilcoxon sign-rank test, Correlation, Rank Correlation, Simple Regression, Multiple Regression.
* Multivariate Statistics: Principal Components Analysis, Correspondence Analysis, Multidimensional Scaling, MANOVA, Canonical Discriminant Analysis.
* Applications: Histogram, Text-to-Columns, Latin Square generation, Patterned data
These files are released under the GNU General Public License (GPL)
Latest release: Version 0.4 (February 11, 2005)
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Mon Sep 17, 2007 4:14 am    Post subject: Reply with quote

"the vendor who sold me this OO product said it would "work seamlessly" in such applications (for Excel.)"

OpenOffice is free for downloading. Why would you buy a free product? If you are referring to "Pop Tools", then is it an "OO product"?

Also, if you do your research you'll see that no two spreadsheet programs are exactly alike. If they were, there'd be copyright issues. You'll also find that no two spreadsheet programs are entirely compatible.

Thirdly, if having issues, why not contact the Pop Tools people to see about possible compatibility problems? This program was clearly written for Excel, having Excel macros. You can check out the various functions [and so see errors] by using a file manager to view the various xls files.

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