Bioequivalence and Bioavailability Forum

Do not trust in computers [Bioanalytics]

posted by Helmut  – Vienna, Austria, 2009-01-22 03:49 (5566 d 07:39 ago) – Posting: # 3101
Views: 24,778

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

Complete thread:

• Excel sheet usage in bioanalytical calculations chbs 2009-01-19 10:35 [Bioanalytics] 
  • do not use excel martin 2009-01-19 11:52
    • do not use excel ? Ohlbe 2009-01-19 23:54
      • Never martin 2009-01-20 14:52
        • Mathematical wizard Helmut 2009-01-20 17:03
          • Do not trust in computers d_labes 2009-01-21 11:00
            • Do not trust in computers Helmut 2009-01-21 13:00
              • Do not trust in computers Ohlbe 2009-01-21 14:03
                • Do not trust in Excelence d_labes 2009-01-21 15:42
                • Do not trust in computersHelmut 2009-01-22 02:49
                  • Do not trust in computers Ohlbe 2009-01-22 10:33
              • Even my calculator... Ohlbe 2009-01-22 22:06
                • Even my calculator... Helmut 2009-01-22 23:26
                  • Even my calculator... ElMaestro 2009-01-23 12:12
                    • Even my calculator... Ohlbe 2009-01-24 19:44
          • data exchange format martin 2009-01-21 12:16
            • Raw data (paper vs. electronic) Helmut 2009-01-21 12:31
          • Mathematical wizard - use WinNonlin Tools menu instead SDavis 2009-01-22 11:56
      • Why not use R? Helmut 2009-01-21 01:02
        • Why not use R? ElMaestro 2009-01-22 19:32
        • Why not use R? ElMaestro 2009-01-23 22:45
          • Why not use R? Aceto81 2009-01-26 16:15
            • Why not use R? d_labes 2009-01-26 16:35