Log in
RegisterRatio calculation of fully replicate study [RSABE / ABEL]
posted by Helmut 
– 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$$
» […] 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]](https://static.bebac.at/img/CC by.png)
The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes
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:
- Ratio calculation of fully replicate study Mithu 2020-07-09 09:18 [RSABE / ABEL]
![[Mix]](https://static.bebac.at/img/mix.png "open in Mix view")
- Ratio calculation of fully replicate studyHelmut 2020-07-09 10:51
- Ratio calculation of fully replicate study Mithu 2020-07-09 11:23
- Ratio calculation of fully replicate study Helmut 2020-07-09 12:19
- Ratio calculation of fully replicate study Mithu 2020-07-09 11:23
- Ratio calculation of fully replicate studyHelmut 2020-07-09 10:51
Ing. Helmut Schütz