cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Buzuddha
Level II

Log transformed data - linear graph axis - Use JSL to draw log ticks

I have biological data that is best displayed with a log-Y axis, the problem is that this causes asymmetric error bars which can extend very misleadingly below the data (if any layer has near zero data).

 

The work around is to create a column to log transform the data, plot on a linear axis and tell the labeller to use a custom formate that is = 10^(:value).

 

The new problem then is the minor axis ticks, which are now on a linear scale and not log. 

 

Two questions:

1) Is it fair statistically to do this? 

2) How to use JSL to draw log ticks when the axis is linear?

3 REPLIES 3

Re: Log transformed data - linear graph axis - Use JSL to draw log ticks

What quantity do your error bars represent? (One standard deviation of the data? One standard error of the statistic? The confidence interval of a statistic?)

Why is the asymmetry undesirable? (On the same scale, the confidence interval of the mean is symmetric but the interval of the standard deviation is not.)

Why did you expect the error bars to be symmetric?

Buzuddha
Level II

Re: Log transformed data - linear graph axis - Use JSL to draw log ticks

Hi Mark,

To answer your questions: I would like it to be one SD, asymmetry is undesirable because the SD on the non-log transformed data goes below the limit of detection and the graph is misleading.

Here’s an example of when I need to use the log transform, these are the same data. Usually I would just do a custom format on the log transformed axis to get the labels to be the same as above:

[cid:image001.png@01D310EF.255E6DD0]

[cid:image002.png@01D310EF.255E6DD0]
Buzuddha
Level II

Re: Log transformed data - linear graph axis - Use JSL to draw log ticks

Also, I would prefer to use the Engineering SI format. 

 

What I have now is:

ScaleBox,

{Format( "Custom", Formula( 10 ^ value ), 10 )

 

This displays a log scale in the right place (without the log minor ticks which I still would like to know how to include). But what would be really helpful is to be able to run the Custom format through the Engineering SI format so that the transformation of the axis labels goes 3 - > 1000 - > 1K. Is this possible?

 

Thanks!