Ask Your Question

Does LibreOffice have comparable program to MS Excel's Data Analysis Toolpak? If so, how to install,use, etc. I'm taking a class and need done by Saturday.

asked 2015-06-11 04:35:17 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Teacher wants us to install to then utilize Data Analysis Toolpak in program. I'm taking an online course and homework is due by this Saturday. I'm a journo, statistics is not my bag. Hence the class. Help is appreciated.


As in LibreOffice 'Math' ('Equation Editor') is the component concerned with pretty formulae, I changed the tags to better meet the content. ( @Lupp )

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-11 07:47:50 +0200

pierre-yves samyn gravatar image


I do not know if all the functions are similar but LibreOffice Calc has since version 4.2 an equivalent module, menu Data Statistics: Sampling, Descriptive Statistics, Analysis of Variance (ANOVA), Correlation, Covariance, Exponential Smoothing, Moving Average, t-test, F-test, z-test,Chi-square Test...

New features are added to each version (4.3, 4.4)


edit flag offensive delete link more


An additional remark: This doesn't need any installation. It's simply there. (Excel, too, seemingly comes with the "toolpak", but doesn't show it in the silly "ribbon" by default. This monster of an UI might overflow if expected to provide access to the complete range of tools by default.)

Lupp gravatar imageLupp ( 2015-06-11 13:19:44 +0200 )edit

As I didn't much statistics for a long time now, I cannot reliably judge. A short visit to the English (GB) help texts concerning the 'Data' > 'Statistics' tools with Version 4.4.3, however, showed a rather well expressed and complete description. It doesn't teach statistics, of course.

Lupp gravatar imageLupp ( 2015-06-11 14:00:00 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2015-06-11 04:35:17 +0200

Seen: 6,391 times

Last updated: Jun 11 '15