Ratio calculation of fully replicate study [RSABE / ABEL]

posted by Helmut Homepage – Vienna, Austria, 2020-07-09 10:51 (807 d 13:30 ago) – Posting: # 21660
Views: 3,057

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
22,385 posts in 4,684 threads, 1,594 registered users;
online 21 (0 registered, 21 guests [including 14 identified bots]).
Forum time: Sunday 00:21 CEST (Europe/Vienna)

You really don’t know what you don’t know until you write about it.
Then, everyone knows what you don’t know.    Rod Machado

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