Spreadshit addiction [General Sta­tis­tics]

posted by yicaoting  – NanKing, China, 2011-10-03 09:23 (4962 d 22:00 ago) – Posting: # 7407
Views: 15,628

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:

UA Flag
Activity
 Admin contact
23,424 posts in 4,927 threads, 1,669 registered users;
73 visitors (0 registered, 73 guests [including 8 identified bots]).
Forum time: 07:23 CEST (Europe/Vienna)

My doctor gave me six months to live,
but when I couldn’t pay the bill
he gave me six months more.    Walter Matthau

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5