cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Grumpybaldprof
Level II

Adjusting y axis labels when plotting box-cox transformed data

JMP® Pro 16.2.0

When plotting box-cox transformed data - how can the y axis value label be set to show the original scale? In log transfomation one can simply select a linear scale and the actual value scale is shown but with log spacings. There does not seem to be any simple way of doing this in y-axis settings. JMP® Pro 16.2.0

 

5 REPLIES 5
Byron_JMP
Staff

Re: Adjusting y axis labels when plotting box-cox transformed data

Maybe post an example of what you're trying to do?

A little more detail might be helpful.

 

JMP Systems Engineer, Health and Life Sciences (Pharma)
Grumpybaldprof
Level II

Re: Adjusting y axis labels when plotting box-cox transformed data

Thanks Byron. For most of my data, that raw regression does not fit the model and having soughte statistical advice, box-cox transformation sorts this out. However, the scales are not the same.

This is a screenshot of the raw regression

Grumpybaldprof_0-1658236892957.png

and here a screenshot of the box-cox transformed regression

Grumpybaldprof_1-1658236938208.png

its clear that the y-axis tick labels are directly based on the transformed data which no surprise. But there seems to be no way to simply instruct JMP to label the ticks with untransformed values. This is why I mentioned the matter of when doing log transformed plots one can select to show the non-transformed values and what happens is the ticks then move to the classic visualisation of a log scale, rather than being equally far appart but labelled with log values.

So my question is around tick labelling not aorund using box-cox transform.

These graphs, with a little tweaking are perfectly publication quality without me having to spend hours messing aroubnd with the very clunky and unintuitive graph builder.

Thanks.

Grumpybaldprof
Level II

Re: Adjusting y axis labels when plotting box-cox transformed data

Good morning Byron, did I provide sufficienbt detail? Thanks. Paul
David_Burnham
Super User (Alumni)

Re: Adjusting y axis labels when plotting box-cox transformed data

I think I understand what you want to do.  It seems entirely reasonable, and also not so easy.  I will at a minimum try and articulate in more detail what you want, with a specific example.

 

Step 1.

David_Burnham_1-1658504478930.png

 

I have my model, which for the special case of a single continuous variable, or one continuous and one discrete (as here) is shown in the Regression Plot outline.

 

In this example its reasonable apparent that variance increases with speed and this can be improved with a Log transformation to the response.  This is confirmed by evaluating Box Cox transformations ( λ = - 0 is equivalent to a log transform).

 

David_Burnham_2-1658504570303.png

 

For convenience of illustration I will take the log transform rather than λ = -0.025.

 

Step 2

From the Box Cox transformation red triangle I can refit with a transform and specify the λ value.

The new model looks like this:

 

David_Burnham_3-1658504795506.png

 

It is linear with respect to the transformed response.  It is clearer to understand the model by looking at the profiler, which shows the y-axis in the un-transformed units:

 

David_Burnham_4-1658504864685.png

 

What I believe @Grumpybaldprof is asking for is the profiler curve on the regression plot. I can make this more explicit:

 

Step 3

This time I return to the Fit Model platform and specify a Log transformation to the response variable. 

 

David_Burnham_5-1658505043196.png

 

Now I get the following Regression Plot :

 

David_Burnham_6-1658505091568.png

 

This I think is what @Grumpybaldprof is looking for.

 

However, I'm only able to achieve this by applying the transformation in the Fit Model dialog and I am limited to the following power transformations:

 

David_Burnham_7-1658505218265.png

 

These correspond to λ values of 0 ,0.5 ,2 , -1 respectively whereas the Box Cox transformation produces a continuum of values.

 

So what to do:

 

  1. Ask JMP to support the box-cox λ parameter when transforming the response, so that the reverse transformation is automatically applied to graphs
  2. Take a sensible interpretation of the Box-Cox transformation (99% of the time I end up taking a log transformation; I would never use λ=-0.025 because I don't know what it means)
  3. Use graph builder to recreate the graph

 

Step 4

Using graph builder - well it's not the easiest thing to do, let alone describe so I will just give a screenshot to show it can be done

 

David_Burnham_8-1658505627592.png

 

 

 

 

 

-Dave
Grumpybaldprof
Level II

Re: Adjusting y axis labels when plotting box-cox transformed data

Thanks David

That is very helpful and moves me forwards a bit. I will ask JMP as you suggest - would it be best to use the JMP Wishlist or is there  better way?

It has also struck me that it might be quicker, meanwhile, to manually relable the axes - but I am certainly not clear on how to get the reverse values out of JMP. Any suggestions?

Cheers

Paul