Re: test of normal distribution functions



One more quite important thing:

You are testing "things that should be equal" and not
"things that should be different".

Some spreadsheets like OO and Excel cheat in the "-" and
"=" operators: things that are mostly equal will be considered
equal, i.e., "-" will return exactly zero.

Such spreadsheets are more likely to pass "should be equal"
tests regardless of their precision!  On the other hand, they
will flunk "should be different" tests more easily.

As a thought experient, consider how many of your tests would
be passed if "-" always returned 0 and normsdist returned 42.
It had better not be all!

Morten



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]