Do not trust in computers [Bioanalytics]

posted by Ohlbe – France, 2009-01-21 14:03 (4469 d 16:36 ago) – Posting: # 3098
Views: 21,170

(edited by Ohlbe on 2009-01-21 23:17)

Dear HS,

Amazing. I fail to reproduce the error in SD calculation in the example you give, using the French version of Excel 2003 I have here. I get the correct value of 1. I'll check with another version of Excel (also French) at home tonight.

Edit: error reproduced at home with the French version of Excel 2000... Shit ! :-(

Does Microsoft also call this a "feature", rather than a bug ?

And considering the fact that the bug appears with some sets of data, but not others, validating a spreadsheet by comparison with another software or manual calculation would not be sufficient.

Regards
Ohlbe

Complete thread:

Activity
 Admin contact
21,419 posts in 4,475 threads, 1,510 registered users;
online 15 (0 registered, 15 guests [including 3 identified bots]).
Forum time: Sunday 07:39 CEST (Europe/Vienna)

Nothing fails like success because you do not learn anything from it.
The only thing we ever learn from is failure.
Success only confirms our superstitions.    Kenneth E. Boulding

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5