Leonard Mada wrote:
USED the NumAcc4 TESTSUITE: (see
http://www.itl.nist.gov/div898/strd/univ/certvalues/numacc4.html )
OK, I have tried the most difficult test case, AND Calc fails (for
CORREL major failure):
- for the mean at the 7th decimal digit
- for SD: at the 10th decimal digit
- I believe Calc should do a little better (at least 12th decimal digit
for the mean)
- accepted results for professional software are usually 14-15 decimal
digits
7th digit? You're not counting the digits behind the decimal point only,
are you?
The correlation coefficient fails poorly:
- made column B = A+1
- C1: =CORREL(A1:A1001; B1:B1001)
- reported correl coeff. = -0.882
- should have been = -0.999
What's the "A+1" supposed to mean?
Anyway, the CORREL function implementation is straight forward and can
certainly be improved. If you want to try, go ahead.
When I will have some more spare time, I will do the remaining tests, too.
But please make sure you're doing them correctly.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
