Ratio calculation of fully replicate study [RSABE / ABEL]

posted by Helmut Homepage – Vienna, Austria, 2020-07-09 10:51 (142 d 16:44 ago) – Posting: # 21660
Views: 1,581

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 🖖
Helmut Schütz

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

Complete thread:

 Admin contact
21,216 posts in 4,427 threads, 1,481 registered users;
online 9 (0 registered, 9 guests [including 9 identified bots]).
Forum time: Sunday 02:35 CET (Europe/Vienna)

Half the harm that is done in this world
Is due to people who want to feel important.    T. S. Eliot

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