Forum Replies Created

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 yaxis from 1.0 to 2.0. I’d like the tic labels to be 100% to 200%.
in reply to: About PercentageMaybe 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.
in reply to: Column of averages of other columnsI used mean(Column1,Column2,Column3) for the mean but standard deviation wasn’t as easy. I used sqrt(((MeanVColumn1)^2+(MeanVColumn2)^2+(MeanVColumn3)^2)/2).
 This reply was modified 11 months ago by pharmpk.
in reply to: Column of averages of other columnsThanks, 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?
Thanks for adding this example. I finally worked out how to use the exponential fit and Extract Power as kel1 and thus halflife by using an expression.
I now have data which appears biexponential with
y = a*exp(b*x) + c*exp(d*t)
so I might be back to an arbitrary fit (using the logarithmic popup to the right of the equation field).
in reply to: Calculating halflifeOK, 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 Halflife1 as log(2)/kel1. The same for the next columns using kel2 and kel3
in reply to: Calculating halflifeGreat, 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.
in reply to: Style Set don’t copy across files Beta 5.0I now see the new split – join workflow that gives a good result as well.
in reply to: Label orientation – extra axis