charting capabilities fro scatter plots

I am wondering whether I can make a scatter plot of subjects’s Cmax data: I have the Cmax data and I need a semilog plot and with the geometric mean and 90% confidence intervals.

It is along the lines of the attached image with 95% confidence intervals from Graph Pad Prism, which does not offer 90% confidence intervals.

Hi Angus,
Can you explain how you have spread in the x-axis for individual Cmax values?

Thanks,
Ana

Anna: I think Prism does this to prevent data points being too close to each other so that you get a better view of the data.

I can trick Phoenix to create something similar to your plot but without spread on the x-axis.
See attached project for some tips.

Ana[attachment=2621:FinalPlot.bmp][attachment=2622:Graphic.phxproj]FinalPlot.bmp (3 MB)Graphic.phxproj (414 KB)

Thank You Ana; I wonder it the range on the y axis can be expanded to prevent overlap of data points.?

Yes, that is data dependent. In this ‘made-up’ example the spread was not very large but you
can always change the y-axis by customizing your own range.

Hope this helps,
Ana

Yes; you can expand the range some what. I must look at how you did this. I have the series of Cmax values onluy need this data.

What is step 1 , step 2, step 3 for me?

Please can you say?

Angus

[quote=“Vineet Sharma, username:sharmavineet”]

Yes; you can expand the range some what. I must look at how you did this. I have the series of Cmax values onluy need this data.

What is step 1 , step 2, step 3 for me?

Please can you say?

Angus

[/quote]Hi Angus,
I tricked the program by assigning some arbitrary values: Cmax values had a new column added with a value 3,
GeoMean has a column with two values 1 and 5, and the 90%CI Geo Mean has values two values 2 and 4. I enter
this in a worksheet and then join them with the NCA and Descriptive stats results. Then in the
plot you overlay the data (3 sets) and have those arbitrary values plotted in the X-axis.
You change titles, remove markers from the CIs and plot formats as you wish. It is hard to
explain so better take a look at the project.

Ana

Yes; Thank you I will look at it first thing early tomorrow. I am a little oversubscribed at the moment.

Ana: the reason I am exploring this is that in a regulatory submission document usually the PK parameters e.g. Cmax are presented in terms of descriptive statistics (mean, standard deviation, CV(%). For a dataset treatment within the same study (with different populations). I have also used the bioequivalence criteria for one comparison in a large stuy with different populations. I have received a comment saying that the descriptive statistics parameter data in analogous way to the one BE comparison should be presented as geometric means (90% CL) using semi-log plots. The justification for this statement is that the BE Guidance (Statistical one..) points out that the PK parameter data be treated is log normally distributed. (IMHOThe BE guidance does not give any reference to why this is so).

I have in fact presented the Cmax parameter e.t.c. data as a scatter plot with a mean and a standard deviation: that is why I am looking at this option that you have helped me with.

Angus

Hi Angus,

Makes sense. PK-metrics follow a lognormal distribution indeed (well, except tmax). See this thread (including a stupid example from the FDA).
The attached project is a starter. Don’t forget to change the specification of the error-bars to ‘Absolute’. I will meet Simon next week and have a chat.

PS: It would be more elegant to use a categorial XY-Plot for the PE&CI (map Dependent to X), but it does not support error bars. Hence, my workaround.

Graphic1.phxproj (1.05 MB)

All,
Note that the next version of Phoenix coming out at the end of this month supports error bars for x-categorical plot. Here is the image of the same plot created with this new version.[attachment=2629:X-Cat_Errors.JPG]

Here is my chart as a snapshot done in Graph Pad Prism: I include the individual data points and Geometric mean with 90% CI of Geometric mean. In this case I had to make two charts and superimpose the two of them using a clear plotting area.