Is it possible to do data analysis in Open Office Calc? I have recently come across the mircosoft data analysis tool add-on, and I was wondering if there was something comparable that can be used with OpenOffice? 
However, if there is nothing for OpenOffice, is there any other software that can be used in Ubuntu-Linux that can do similar things?
 A: Gnumeric 
http://projects.gnome.org/gnumeric/
will do various statistical analyses. After installation they are found under Statistics in the top (File, Edit, etc.) menu.
A: Yes, you can do statistics in Open Office Calc:


*

*Here is a list of statistical functions in LibreOffice Calc

*Possibly out of date suggestions


*

*There is an add on called R and Calc (page last modified in 2008; ymmv) that allows the user to call R functions from within Open Office.

*Calc's data analysis tool is under development. 
(page last modified in 2008) 



However, the spreadsheet interface can get in the way of data analysis, and is often not the appropriate tool for the job. 


*

*If you are primarily interested in data analysis, it is worth checking out the Deducer or Rstudio interfaces to R.

*Ggobi is a good tool for data visualization. (Update: also pre-2010)
A: First post here!
I've used this:
http://sourceforge.net/projects/ooomacros/files/OOo%20Statistics/
to do stats in openoffice (and recommended it to others as well).
I usually use R but sometimes a quick look is all you need.
best
i 
A: Sofastats looks really well done, and it can import from OpenOffice files.
http://www.sofastatistics.com/
