Bioequivalence and Bioavailability Forum

Spreadshit addiction [General Statistics]

posted by yicaoting – NanKing, China, 2011-10-03 09:23 (5017 d 03:14 ago) – Posting: # 7407
Views: 15,968

I am very glad to report my test of MS Excel 2010's BetaInv() Function.

Excel 2000, 20003, or 2007:
BETAINV(0.001,2,4)=0.010101318359375

Excel 2010:
BETAINV(0.001,2,4)=0.0101017878837378

SAS 9.1:
BETAINV(0.001,2,4)=0.0101017879

OO Calc 3.3
BETAINV(0.001,2,4)=0.0101017878837378

R 2.13.0

qbeta(0.001,2,4)

[1] 0.01010178788373775407572

Now, I am satisfied with MS's improvement on MS Excel 2010.
What about you?

But I want to ask HS, before you used user-defined function NctInv() function, how could you do Welch's t-test for 2-group parallel BE analysis with unequal variances in your "Manual Excel 2000" which was frequently appeared in your PPTs?

I am highly interest in your Excel template for BE analysis, would you like to share it with me for personal in-house use?

Complete thread:

Welch/Satterthwaite in practice ElMaestro 2011-09-21 17:04 [General Statistics]
- Not to round is the question d_labes 2011-09-22 09:11
  - my problem ElMaestro 2011-09-22 12:34
    - Ways out d_labes 2011-09-27 11:54
- Welch/Satterthwaite in practice yicaoting 2011-09-29 16:29
  - Welch/Satterthwaite in practice ElMaestro 2011-09-29 17:39
  - Spreadshit addiction Helmut 2011-09-30 16:52
    - what a divine post! ElMaestro 2011-09-30 18:54
      - what a divine post! Helmut 2011-09-30 19:41
        
        what a divine post! ElMaestro 2011-10-01 13:03
        
        what a divine post! Helmut 2011-10-01 13:20
    - Spreadshit addiction yicaoting 2011-10-01 05:36
      - Spreadshit addiction ElMaestro 2011-10-01 11:13
        
        GNU addiction Helmut 2011-10-02 03:20
      - Spreadshit addiction Helmut 2011-10-01 13:03
        
        Spreadshit addiction yicaoting 2011-10-01 16:39
        Spreadshit addictionyicaoting 2011-10-03 07:23
        
        Spreadshit addiction Helmut 2011-10-03 15:59
        
        Spreadshit addiction yicaoting 2011-10-03 17:35
        
        Spreadshit addiction Helmut 2011-10-03 17:41

Spreadshit addiction [General Sta­tis­tics]

Complete thread:

Spreadshit addiction [General Statistics]