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

Hi Mithu,

Without knowing your SAS code it would be reading tea leaves. Why on earth do you want to use Excel?

❝ […] 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.

—

Helmut Schütz

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