PK & Stat analysis of BA/BE data in MS-Excel [Software]

posted by ElMaestro  – Denmark, 2009-08-07 21:04 (6154 d 04:08 ago) – Posting: # 4017
Views: 10,054

Hi Sree,

A good place to start is the book by Chow and Liu "Design and analysis of bioavailability and bioequivalence studies".
It describes a way of doing the BE-ANOVA without model fitting, and it also -and this is where I think you easily could gets started with Excel- tells how to derive the statistics without ANOVA, but using t-test in stead.
As it happens, the two methods should ideally give the same results ( in terms of p-values), but they do not in case of imbalance, where the t-test approach gives you p-values that correspond to ANOVA based on model fits with type III sums of squares and they are generally accepted.
All in all, it is a jungle out there. In order to calculate your BE-statistics for a standard 2,2,2-BE study you can thus use a linear model* and play with factor inclusion to obtain the ANOVA (with for example type III SS), or you can do the ANOVA without a model fit by way of the reference above, or you can do it all without ANOVA and just do a series of t-tests (and get p-values corresponding to type III SS).

Best regards
EM.


*: You can even use a (linear) mixed model with subjects as random factor.

Complete thread:

UA Flag
Activity
 Admin contact
23,653 posts in 4,991 threads, 1,570 registered users;
143 visitors (0 registered, 143 guests [including 31 identified bots]).
Forum time: 01:12 CEST (Europe/Vienna)

To propose that poor design can be corrected by subtle analysis techniques
is contrary to good scientific thinking.    Stuart J. Pocock

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