pharmpk's Replies

[pharmpk]

I have data in Numbers as percentage. I’ve converted them to numbers. Copy the table and pasted in DataGraph. All the columns are now numbers, 3. If I paste the percentage the columns are text, ab. OK, so I have a nice graph with y-axis from -1.0 to 2.0. I’d like the tic labels to be -100% to 200%.

[pharmpk]

Maybe also an easy way to include any number(n) of columns. I just tried defining a group of columns in the mean(group) calculation but it didn’t seem to work.

[pharmpk]

I used mean(Column1,Column2,Column3) for the mean but standard deviation wasn’t as easy. I used sqrt(((MeanV-Column1)^2+(MeanV-Column2)^2+(MeanV-Column3)^2)/2).

• This reply was modified 11 months ago by pharmpk.

[pharmpk]

Thanks, this helps. I’m still working through the weighting functions. I’ve always thought relative weight would be equivalent to 1/(y*y) but that doesn’t seem to work.

Do the residual plots show the weight residual when appropriate on the y axis?

[pharmpk]

Thanks for adding this example. I finally worked out how to use the exponential fit and Extract Power as kel1 and thus half-life by using an expression.

I now have data which appears bi-exponential with

y = a*exp(-b*x) + c*exp(-d*t)

so I might be back to an arbitrary fit (using the logarithmic pop-up to the right of the equation field).

[pharmpk]

OK, I have an answer. Maybe not the best but seems to work

I set the Fit function to arbitrary as a*exp(-b*x) with x = Time (column)

The fit gave me values of a and b (= kel1). I then calculated Half-life1 as log(2)/kel1. The same for the next columns using kel2 and kel3

 

 

[pharmpk]

Great, thanks. That works…however, the size in the chart pane shows automatic, but if I choose Custom it recognizes the custom size and adjusts the graph from the previous graph – style set correctly. Thanks for the clearer explanation.

[pharmpk]

I now see the new split – join workflow that gives a good result as well.