Hi Leonard,
On 10/23/06, Leonard Mada <[EMAIL PROTECTED]> wrote:
What I can do, is:
- create some test-cases
- test a test case against R (especially this!!!)
- lobbying for R-integration (especially for more advanced statistical
functions)
I've done something similar in the past. Take a
Niklas Nebel wrote:
I noticed that Calc calculates the SUM in the same order as that of
the data cells. However I was reading somewhere (though do not
remember anymore where) that it is best to calculate the sum by:
1. ordering the numbers from smallest to largest (as absolute
numbers, i.e. wit
Leonard Mada wrote:
I noticed that Calc calculates the SUM in the same order as that of the
data cells. However I was reading somewhere (though do not remember
anymore where) that it is best to calculate the sum by:
1. ordering the numbers from smallest to largest (as absolute numbers,
i.e. wit
Hi,
I was thinking again on the sum issue. Indeed, if you read my last post
(the TestCase with the Spreadsheet where 3 columns with the *same* data
yielded different results), there is a problem in the summation of cells.
PROBLEM
The sum is one of the most elemental operations in a s
Hi,
Some people complain that a large number of Calc patches is piling up at
ooo-build and we at Sun are ignoring or delaying them. To counter this
impression, we (the core Calc team at Sun) went through the Calc section
of the list at http://go-oo.org/ooo-build/patches/src680/apply, and
sort
This is only a corrected attachement (even better results, when sorting
adequately, BUT a lot of work to sort it that way).
Kind regards,
Leonard Mada
Calc-Test-Sheet-SUM.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--
I noticed that Calc calculates the SUM in the same order as that of the
data cells. However I was reading somewhere (though do not remember
anymore where) that it is best to calculate the sum by:
1. ordering the numbers from smallest to largest (as absolute numbers,
i.e. without sign)
2. adding
OK, I have found that most of the code is in
sc/source/core/tool/interpr*.cxx, especially in interpr3.cxx and
interpr5.cxx. I do know some C++, but unfortunately have very limited
time (I also work hard on the statistical wiki page,
http://wiki.services.openoffice.org/wiki/Statistical_Data_Anal
Leonard Mada wrote:
I was wondering what coding algorithm does Calc use when implementing
the various statistical functions?
REASON
===
Although different formulas are mathematically identical, they give
different *error estimates* when coded on a computer.
EXAMPLE
The variance