Issue 4921 - Advanced statistics functions.
Summary: Advanced statistics functions.
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial with 8 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 59845 (view as issue list)
Depends on:
Reported: 2002-05-15 23:47 UTC by Unknown
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Partial Patch: ScANOVA() C++ implementation (6.38 KB, text/plain)
2007-04-22 21:17 UTC, discoleo
no flags Details
Sample C++ Test Code for ANOVA function (compiled with MS VC6) (7.23 KB, text/plain)
2007-04-22 21:23 UTC, discoleo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-05-15 23:47:06 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.
Comment 1 frank 2002-05-16 09:15:34 UTC
Hi Daniel,

I know it's per definition something for Falko, but I think you should
have a loook at it first.

Comment 2 daniel.rentz 2002-05-22 07:34:02 UTC
Hi Roberto,
Please write me a little bit more about the requested functions. Is 
ANOVA the english name of the function?
Comment 3 daniel.rentz 2002-06-14 15:58:43 UTC
Link for a sample 
Comment 4 daniel.rentz 2003-01-21 17:25:13 UTC
Comment 5 apksr 2003-05-23 14:58:25 UTC
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?
Comment 6 daniel.rentz 2003-09-16 09:59:09 UTC
Comment 7 oc 2003-09-22 10:40:09 UTC
According to the roadmap
( this issue was retargeted to
OOo Later.
Comment 8 aziem 2005-12-28 22:43:04 UTC
*** Issue 59845 has been marked as a duplicate of this issue. ***
Comment 9 kimmie_231 2006-01-02 11:21:37 UTC
I downloaded the patch with OOstats. It lacks many things like descriptive
statistics and forecast. I hope it can be fixed.

Thank you
Comment 10 discoleo 2006-08-09 23:45:47 UTC
Many of these problems could be solved, if Calc would be integrated with the
R-statistical software.

and also the wiki page,

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.
Comment 11 discoleo 2007-04-22 21:17:32 UTC
Created attachment 44595 [details]
Partial Patch: ScANOVA() C++ implementation
Comment 12 discoleo 2007-04-22 21:23:48 UTC
Created attachment 44596 [details]
Sample C++ Test Code for ANOVA function (compiled with MS VC6)
Comment 13 discoleo 2007-04-22 21:28:43 UTC
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.
Comment 14 keanboon517 2008-04-13 12:02:57 UTC
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?