Bioequivalence and Bioavailability Forum

Main page Policy/Terms of Use Abbreviations Latest Posts

 Log-in |  Register |  Search

Back to the forum  Query: 2018-04-25 10:32 CEST (UTC+2h)
 

Do not trust in computers [Bioanalytics]

posted by Helmut Homepage - Vienna, Austria, 2009-01-22 02:49  - Posting: # 3101
Views: 15,463

Dear Ohlbe,

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

[image]If you boil this page down, bug. Although they don’t confess that pre-2003 was buggy – they use some kind of Newspeak.

They give also this formula
SQRT((SUMSQ(values)-(SUM(values)^2)/COUNT(values))/(COUNT(values)-1))
as ‘at least a good approximation to the value of STDEV as found by earlier versions of Excel.’

There was a major change between v2003 and its predecessors. See this overview in Microsoft’s Knowledge Base.

[image]Regards,
Helmut Schütz 
[image]

The quality of responses received is directly proportional to the quality of the question asked. ☼
Science Quotes

Complete thread:

Back to the forum Activity
 Mix view
Bioequivalence and Bioavailability Forum | Admin contact
18,208 posts in 3,871 threads, 1,154 registered users;
36 users online (0 registered, 36 guests).

Mediocrity finds safety in standardization.    Frederick E. Crane

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