|
PureBytes Links
Trading Reference Links
|
Now that last line was FUNNY! :)
Bill
--- In amibroker@xxxx, "Richard Alford" <richard.alford@xxxx> wrote:
> 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
>
> ----- Original Message -----
> From: b519b
> To: amibroker@xxxx
> 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.
>
> http://web.polmeth.ufl.edu/papers/99/altmcd99.pdf
>
> b
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
|