Ratio calculation of fully replicate study [RSABE / ABEL]

posted by Helmut Homepage – Vienna, Austria, 2020-07-09 12:51 (1436 d 04:23 ago) – Posting: # 21660
Views: 4,400

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,056 posts in 4,840 threads, 1,641 registered users;
150 visitors (0 registered, 150 guests [including 77 identified bots]).
Forum time: 17:14 CEST (Europe/Vienna)

Exploratory analysis: The art of finding a Rembrandt
in a Jackson Pollock.    Stephen Senn

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