Ratio calculation of fully replicate study [RSABE / ABEL]

posted by Helmut Homepage – Vienna, Austria, 2020-07-09 12:51 (1806 d 17:04 ago) – Posting: # 21660
Views: 6,351

Hi Mithu,

❝ […] how to calculate ratio of fully replicate study in excel?

❝ I have prepared one excel sheet in which i have put formula to calculate Partial AUC and AUC0-t.

❝ I am getting correct PK for CMax & AUC's in line with SAS out put but when i am calculating Ratio, it is not matching with SAS out put.


Without knowing your SAS code it would be reading tea leaves. Why on earth do you want to use Excel?

❝ Process followed to calculate ratio in excel is as follows:

❝ 1. from two T and two R taking average and then taking ratio of T /R.

❝ 2. Other case, i had also converted average of both T & R in LN and then taken ratio of LN T & LN R.

$$x/y=\exp (\log_{e}x-\log_{e}y)\;\left\{x,y \in \mathbb{R}^{+} \right\}\; {\color{red}{\neq}}\log_{e}x/\log_{e}y$$

Dif-tor heh smusma 🖖🏼 Довге життя Україна! [image]
Helmut Schütz
[image]

The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes

Complete thread:

UA Flag
Activity
 Admin contact
23,424 posts in 4,927 threads, 1,676 registered users;
40 visitors (0 registered, 40 guests [including 9 identified bots]).
Forum time: 05:55 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