Spreadshit addiction [General Sta­tis­tics]

posted by yicaoting  – NanKing, China, 2011-10-03 09:23 (5369 d 10:43 ago) – Posting: # 7407
Views: 19,221

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,654 posts in 4,992 threads, 1,570 registered users;
124 visitors (0 registered, 124 guests [including 14 identified bots]).
Forum time: 20:06 CEST (Europe/Vienna)

The idea is to try and give all the information to help others
to judge the value of your contribution;
not just the information that leads to judgment
in one particular direction or another.    Richard Feynman

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