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

posted by ElMaestro  – Denmark, 2009-08-07 21:04 (5795 d 16:06 ago) – Posting: # 4017
Views: 8,712

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,424 posts in 4,927 threads, 1,676 registered users;
32 visitors (0 registered, 32 guests [including 5 identified bots]).
Forum time: 13:11 CEST (Europe/Vienna)

Complex, statistically improbable things are by their nature
more difficult to explain than
simple, statistically probable things.    Richard Dawkins

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