## Ratio calculation of fully replicate study [RSABE / ABEL]

Dear All,

Hope all are doing well in such pandemic condition.

Today my question is, 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.

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.

In both of the cases, i could not get ratio as per SAS. Does SAS has some other formula to calculate ratio?

Please help and educate me to calculate correct ratio of fully replicate study in line with SAS out put.

Please stay safe.

Regards,

Mithu

Edit: Category changed. [Helmut]

Hope all are doing well in such pandemic condition.

Today my question is, 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.

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.

In both of the cases, i could not get ratio as per SAS. Does SAS has some other formula to calculate ratio?

Please help and educate me to calculate correct ratio of fully replicate study in line with SAS out put.

Please stay safe.

Regards,

Mithu

Edit: Category changed. [Helmut]

### Complete thread:

- Ratio calculation of fully replicate studyMithu 2020-07-09 09:18 [RSABE / ABEL]
- Ratio calculation of fully replicate study Helmut 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 study Helmut 2020-07-09 10:51