To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66589
                  Issue #:|66589
                  Summary:|R Statistical Software
                Component:|Spreadsheet
                  Version:|OOo 2.0.2
                 Platform:|All
                      URL:|
               OS/Version:|All
                   Status:|UNCONFIRMED
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|FEATURE
                 Priority:|P3
             Subcomponent:|code
              Assigned to:|spreadsheet
              Reported by:|discoleo





------- Additional comments from [EMAIL PROTECTED] Tue Jun 20 05:12:16 -0700 
2006 -------
This feature request will deal with the OOo-Calc program, more specifically with
its statistical functions.

I have sometimes the feeling that OOo tries to reinvent the wheel. Sometimes we
may need a square wheel, but more often the time-proven round wheel is the
better choice.

How does my remark apply to Calc? While the statistical functions offered by
Calc are reasonable, they cannot compete with dedicated statistical programmes.
(I will post a separate, similar request for gawk support.)

Fortunately, there is an open source state-of-the-art statistical program called
R (http://www.R-project.org). Therefore I think it is reasonable to integrate R
with Calc, instead of writing new statistical functions.

My 2 wishes are:
1. the OOo help file should mention the existence of R (and provide the web
address for download)
2. Calc should be integrated tightly with R: I'll detail this in the next 
paragraph.

When I perform some serious statistical analysis, I have to export first a file
from Calc and then import it into R. This is time-consuming. I would like to
open a pipeline to R and perform the calculations within Calc, bypassing the
need for an intermediate file. (This should be possible, because R is open
source, too.)

I will briefly mention some advantages of R:
 - over 100 additional packages available
   e.g. Fisher exact-test, bootstrap procedure and other non-parametric tests
 - linear regression models (including glm, generalized linear regression), as
well as non-linear models
 - it is actually a statistical programming language, therefore one can write
his own statistic
 - complex statistical tests: ROC-curves, Cox-proportional hazards;
 - availability for both UNIX and MS Windows systems

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to