|
PureBytes Links
Trading Reference Links
|
Interesting article, although I will not lose sleep
over the issue. The answers should always fit mental "reasonableness
criteria" and I suspect I can detect errors O(10^8), btw 10^8 is a bit bigger
than a million....
At any rate, I am sure this will be the reason for
WCOM's issue and Billy Buck$ will make good to all the investors.
Cheers,
Richard
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
b519b
To: <A title=amibroker@xxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Tuesday, July 09, 2002 12:08
AM
Subject: [amibroker] Statistical Errors
in Excel
Although this may seem a bit off topic, it may be very
important to those who use Excel (and some other programs) to
statistically analyze results from AB. The following study reports
that for certain data sets, Excel's results can be off by as much as 8
orders of magnitude (ie, 1 million times too low or too high). Microsoft
cynics may not be surprised by this, but I find it shocking that this
"flaw" is in Excel "by design" according to authors of the study.
Apparently Excel uses a mathematical short cut for some statistical sums
that works in many cases but fails in other.<A
href="">http://web.polmeth.ufl.edu/papers/99/altmcd99.pdfbYour
use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
|