Ratio calculation of fully replicate study [RSABE / ABEL]

posted by Helmut Homepage – Vienna, Austria, 2020-07-09 10:51 (286 d 05:02 ago) – Posting: # 21660
Views: 1,923

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
[image]

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

Complete thread:

Activity
 Admin contact
21,419 posts in 4,475 threads, 1,510 registered users;
online 13 (0 registered, 13 guests [including 4 identified bots]).
Forum time: Wednesday 15:53 CEST (Europe/Vienna)

In the Middles Ages the lingua franca of science was Latin.
Nowadays the language of science is bad English.    Anonymous

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