## Do not trust in computers [Bioanalytics]

Dear Ohlbe,

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

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.

Dif-tor heh smusma 🖖
Helmut Schütz

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