Jump to content


Photo

LOG-transformed data


  • Please log in to reply
3 replies to this topic

#1 Nino

Nino

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 27 July 2010 - 12:22 PM

dear all

 

I'm new in the project and just clearing up in it.

 

for my bioequivalence study I need log-transformation of several datas, such as AUC(0-t); AUC(0-inf) , Cmax and so on, but unfortunately was not able to find how to do it.

 

Please help me,

waiting forward hearing from you

Sincerely

Ms nino

tbilisi, Georgia



#2 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,331 posts

Posted 27 July 2010 - 12:42 PM

Nino, if you need this log transformed data to perform bioequivalence then you should look at the Bioequivalence Wizard under NCA and Toolbox where you will see that it will actually LogTransform the data for you as part of the process. Posted Image

However if you need to LogTransform data still it is very easy to send it to a Column Transformation tool and using custom create the desired additional columns.

the syntax just goes inthe box e.g. ln(auclast) and you map AUClast as the input.

Simon. Posted Image

Attached Thumbnails

  • log_transform.jpg
  • BE_wizard.jpg


#3 Nino

Nino

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 27 July 2010 - 01:18 PM

thanks Simon, it was quite easy



#4 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,331 posts

Posted 29 July 2010 - 12:11 PM

Nino - I merged your previous thread into this one as they are a continuation of the same question.

dear all
how can I transform the whole table (worksheet) into LOG - form?

Sincerely
Ms Nino


I see two options.

a) perform a column transformation for each column you need as discussed in your previous thread.

B) if you have lots of columns to transform first use 'Stacker' to pivot the work sheet to a tall-skinny format of a single column. and then log transform that one column.

If you are working with NCA out put you should not that there is already a worksheet containing final parameters in that format; "Final Parameters"

I hope that answers your question, to be honest I am not quite understanding why you need to log transform a whole worksheet

Simon.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users