Bioequivalence and Bioavailability Forum

Main page Policy/Terms of Use Abbreviations Latest Posts

 Log-in |  Register |  Search

Back to the forum  Query: 2018-01-19 23:53 CET (UTC+1h)
 

Do not trust in computers [Bioanalytics]

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

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
17,720 Posts in 3,785 Threads, 1,104 registered users;
29 users online (0 registered, 29 guests).

No matter what side of the argument you are on,
you always find people on your side
that you wish were on the other.    Thomas Berger

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