6

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?

picakhu
  • 161
  • 1
  • 1
  • 3
  • related: http://stats.stackexchange.com/questions/3/what-are-some-valuable-statistical-analysis-open-source-projects – David LeBauer Jul 29 '11 at 16:26
  • [This add-on can do t-test, plot histogram and even calculate covariance](http://office.microsoft.com/en-us/excel-help/about-statistical-analysis-tools-HP005203873.aspx)! Stunning. –  Jul 29 '11 at 16:46
  • 4
    Better use a true data analysis software. The functionalities offered in speadsheets are very limited and often just boil down to exporting the data into a better software such as R or ELKI, then analyzing it, then importing it back into the speadsheet. Doesn't make much sense to me... – Has QUIT--Anony-Mousse Dec 06 '11 at 09:52

4 Answers4

17

Yes, you can do statistics in Open Office Calc:

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)

David LeBauer
  • 7,060
  • 6
  • 44
  • 89
2

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.J.
  • 21
  • 1
1

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

duff
  • 151
  • 5
  • I managed to install this for OO, my problem is that I am trying to find the error in the slope. I know that it can be done on excel, but I am not sure how it can be done in open office. I should have probably made that clear. – picakhu Jul 30 '11 at 18:39
  • @picakhu, the best way to do that in Oo would be to use the arithmetic functions to solve the equation (and perhaps you could ask another question if you have trouble with that) – David LeBauer Jul 30 '11 at 22:35
0

Sofastats looks really well done, and it can import from OpenOffice files.

http://www.sofastatistics.com/

Jared Forsyth
  • 101
  • 1