Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 11 Jun 2015 14:00:00 +0200Does 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.https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/ 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.
=EDITING=
As in LibreOffice 'Math' ('Equation Editor') is the component concerned with pretty formulae, I changed the tags to better meet the content.
( @Lupp )Thu, 11 Jun 2015 04:35:17 +0200https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/Answer by pierre-yves samyn for <p>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. </p>
<p>=EDITING=</p>
<p>As in LibreOffice 'Math' ('Equation Editor') is the component concerned with pretty formulae, I changed the tags to better meet the content.
( <a href="/en/users/11185/lupp/">@Lupp</a> )</p>
https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/?answer=51777#post-id-51777Hi
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)
RegardsThu, 11 Jun 2015 07:47:50 +0200https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/?answer=51777#post-id-51777Comment by Lupp for <p>Hi</p>
<p>I do not know if all the functions are similar but LibreOffice Calc has since version 4.2 an equivalent module, menu <code>Data</code> <code>Statistics</code>: Sampling, Descriptive Statistics, Analysis of Variance (ANOVA), Correlation, Covariance, Exponential Smoothing, Moving Average, t-test, F-test, z-test,Chi-square Test...</p>
<p>New features are added to each version (4.3, 4.4)</p>
<p>Regards</p>
https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/?comment=51798#post-id-51798As 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.Thu, 11 Jun 2015 14:00:00 +0200https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/?comment=51798#post-id-51798Comment by Lupp for <p>Hi</p>
<p>I do not know if all the functions are similar but LibreOffice Calc has since version 4.2 an equivalent module, menu <code>Data</code> <code>Statistics</code>: Sampling, Descriptive Statistics, Analysis of Variance (ANOVA), Correlation, Covariance, Exponential Smoothing, Moving Average, t-test, F-test, z-test,Chi-square Test...</p>
<p>New features are added to each version (4.3, 4.4)</p>
<p>Regards</p>
https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/?comment=51792#post-id-51792An 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.)Thu, 11 Jun 2015 13:19:44 +0200https://ask.libreoffice.org/en/question/51775/does-libreoffice-have-comparable-program-to-ms-excels-data-analysis-toolpak-if-so-how-to-installuse-etc-im-taking-a-class-and-need-done-by-saturday/?comment=51792#post-id-51792