Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
miltonwall
Level I

Box Plot Axis Problem

I've long used JMP to make box plots to show the distributin of data for a number of field sites on the same axis. I recently upgraded to JMP 14 and now the axis look different than they have in the past. Specifically, I'm running into an issue where the axis seems homogenized regardless of where the actual outliers are. For instance, in the old format if the outlier was 20000 then it would plot 4x higher than an outlier for a different site with a max outlier of 5000. To minimize these, we use a log axis and it looks something like this:

 JMP1.JPG

However, in the new version, the top of the y-axis is the same for every dataset even if they are very different. Instead, the outermost datapoint simply has a label on it. It goes without saying that this signifficantly impacts where the median would appear to be. Further, since all the sites don't have the same axis, there aren't actually labels on the y-axis which makes the whole thing somewhat pointless. Here is what that looks like:

JMP2.JPG

Things I've tried without sucess:

1) changing modeling type from continuous to ordinal

2) editing all sorts of axis settings. In fact, the one that I understand the least is the fact that the maxium on th scale is set to 1.02 even though there is a ton of data above that number. That seems to indicate that the axis is auto-scaled but I can't figure out how to change it. Well, I can change it but it doesn't seem to help. Here is what the settings look like:
JMP3.JPG

Thanks for any and all help!

Brad

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Box Plot Axis Problem

Please try what I suggested. Tables > Stack. Select the 16 data columns and click Stack. Enter the name of the data in the Data Column. Enter Site for the Label Column.

 

Now you should be able to use the data column for Y and the label column for X. The scaling issue should not occur.

Learn it once, use it forever!

View solution in original post

6 REPLIES 6
Highlighted

Re: Box Plot Axis Problem

The first example has a single column with many levels. It is a single Y. In the second example, you plotted 16 columns on the X axis. Try stacking the 16 columns and use the new lable column in the X role as before.

Learn it once, use it forever!
Highlighted
miltonwall
Level I

Re: Box Plot Axis Problem

I somewhat see what you mean but the first one was always from multiple columns as well. I just didn't bother to rename the columns in the second one because I've been rebuilding it so often to see if I could get it to work. This data has always been organized with a column for each site and there isn't an easy way to reformat it because it doesn't have a column that identifies which site each datapoint is related to.

Highlighted

Re: Box Plot Axis Problem

Please try what I suggested. Tables > Stack. Select the 16 data columns and click Stack. Enter the name of the data in the Data Column. Enter Site for the Label Column.

 

Now you should be able to use the data column for Y and the label column for X. The scaling issue should not occur.

Learn it once, use it forever!

View solution in original post

Highlighted

Re: Box Plot Axis Problem

I am using Big Class as the example. Here is the result when I stack four numeric data columns:

 

Capture.PNG

 

Here is the same data plotted as the original separate (un-stacked) columns:

 

Capture.PNG

 

Can you see the parallels between these results and the two of your own posted at the beginning?

Learn it once, use it forever!
Highlighted
miltonwall
Level I

Re: Box Plot Axis Problem

Thanks for the detailed steps. I'll give it a try.

Highlighted
miltonwall
Level I

Re: Box Plot Axis Problem

Thanks for your help. That seems to work well. I'm a bit confused as to why it has changed through time becaues it used to work the other way (I've certainly never used the stack feature). Nonetheless, I'm happy to have a solution.

Thanks,
Brad

Article Labels

    There are no labels assigned to this post.