Bioequivalence and Bioavailability Forum 20:14 CEST

Main page Policy/Terms of Use Abbreviations Latest Posts

 Log in |  Register |  Search

Do not trust in computers [Bioanalytics]

posted by Ohlbe - France, 2009-01-21 14:03  - Posting: # 3098
Views: 16,572

(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
 Mix view
Bioequivalence and Bioavailability Forum |  Admin contact
18,783 posts in 4,003 threads, 1,258 registered users;
online 12 (0 registered, 12 guests [including 10 identified bots]).

To propose that poor design can be corrected by subtle analysis techniques
is contrary to good scientific thinking.    Stuart J. Pocock

The BIOEQUIVALENCE / BIOAVAILABILITY FORUM is hosted by
BEBAC Ing. Helmut Schütz
HTML5 RSS Feed