Bioequivalence and Bioavailability Forum • Do not trust in Excelence

Do not trust in Excelence [Bioanalytics]

posted by d_labes – Berlin, Germany, 2009-01-21 16:42 (6367 d 20:58 ago) – Posting: # 3099
Views: 32,548

Dear HS, dear Ohlbe,

seems we are going to validate M$ Excel, which we will never, never, never use for any statistics?
Amazing! :-D

To add my two coins:
Excel 2003 SP3 (german), Windows XP professional on a DELL Pentium 4 (3.0 GHz) machine with 1 GB RAM, chip set graphics .........

    |       A       

    +---------------

  1 | 90000001      

  2 | 90000002      

  3 | 90000003      

  4 | =MITTELWERT(A1:A3) 

  5 | =STABW(A1:A3)

gives

    |       A       

    +---------------

  1 | 90000001      

  2 | 90000002     

  3 | 90000003     

  4 | 90000002     

  5 | 1

For me the result in WinNonlin in Helmut's post is more interesting!
Seems they (far side) have validated it against Helmut's Excel version. :-P

That adds much credit to the trustworthyness in WinNonlin results of iterative REML analyses of replicate cross-over designs with factor analytic decomposition of the between covariance matrix. Really! :rotfl:

—
Regards,

Detlew

Complete thread:

Excel sheet usage in bioanalytical calculations chbs 2009-01-19 10:35
- 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 Excelenced_labes 2009-01-21 15:42
        Do not trust in computers Helmut 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