Apache OpenOffice (AOO) Bugzilla – Issue 4921
Advanced statistics functions.
Last modified: 2013-08-07 15:12:27 UTC
Would it be possible to include ANOVA (with and without replication), and T test for pairs. (Just as in M$ Excel Tools-- Data Analysis) And perhaps, even better, to include nonparametric tests as Kruskall-Wallis, or Mann Whitney? I m not a programmer, so i can't write the code, but if you need any help (formulas) please contact me.
Hi Daniel, I know it's per definition something for Falko, but I think you should have a loook at it first. Frank
Hi Roberto, Please write me a little bit more about the requested functions. Is ANOVA the english name of the function? Daniel
Link for a sample document http://ooextras.sourceforge.net/modules.php?name=Downloads&d_op=getit&lid=29
target->OOo2.0
Can this feature be extended to include a plug-in from the statistical package R? Like R-Excel or R-GNUMERIC (see link below). Or should I submit a separate issue? http://www.sciviews.org/_rgui/
.
According to the OpenOffice.org roadmap (http://tools.openoffice.org/releases) this issue was retargeted to OOo Later.
*** Issue 59845 has been marked as a duplicate of this issue. ***
I downloaded the patch with OOstats. It lacks many things like descriptive statistics and forecast. I hope it can be fixed. Thank you
Many of these problems could be solved, if Calc would be integrated with the R-statistical software. see http://qa.openoffice.org/issues/show_bug.cgi?id=66589 and also the wiki page, http://wiki.services.openoffice.org/wiki/Statistical_Data_Analysis_Tool Indeed, there are many modern methods that are difficult to implement (like bootstrap and other resampling procedures), therefore tight integration of external software, where such free software exists, is the better approach. If you feel that this is the better approach (as I personally do), please vote for that issue (66589), because it offers a more global approach to the problem.
Created attachment 44595 [details] Partial Patch: ScANOVA() C++ implementation
Created attachment 44596 [details] Sample C++ Test Code for ANOVA function (compiled with MS VC6)
I have posted some sample C++ code above, implementing (partially) the one way ANOVA method. The Calc-ANOVA-No_ARRAY.cpp impelements the Calc functions that calculate the ANOVA. There are still some things to be done (like FDIST() to be called), but most of the code should be functional. The ANOVA.Test.Code.cpp contains the ANOVA code embedded in a testing framework, so that one can test code changes, without having to bother about OOo. It can be compiled with MS VC6.0, though I have NO idea, if other compilers (especially newer ones) would still compile it.
In Microsoft Excel, Data Analysis and Data Analysis can be installed as a plugin tool. It can do things like summarising a data entry into mean, median, mode, skewness, kurtosis, total, minimum, maximum, standard deviation, sample variance, range and so on. It is called decriptice statistics, in Data Analysis. Can Open Calc do that? Enable installation?