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?


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)




will do various statistical analyses. After installation they are found under Statistics in the top (File, Edit, etc.) menu.


First post here!

I've used this:


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.



  • $\begingroup$ 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. $\endgroup$ – picakhu Jul 30 '11 at 18:39
  • $\begingroup$ @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) $\endgroup$ – David LeBauer Jul 30 '11 at 22:35

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



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.