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
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. 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.
thanks Simon, it was quite easy
Nino - I merged your previous thread into this one as they are a continuation of the same question. [color=#408040]dear all how can I transform the whole table (worksheet) into LOG - form? Sincerely Ms Nino[/color] 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.