cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
JMPJenna
JMPJenna
Level I

"Points Spread" Function: Order of Points

Dec 17, 2018 01:59 PM (3866 views)

Hello JMP Community,

 

I am using the Points Spread function in the Fit Y by X platform for oneway analysis. It seems that, by default, the points are spread in reverse order of the order of data in the data table. Meaning, for each X-axis variable, the points are spread from highest row number to lowest row number (left to right).

 

Why is this, and can I change the order of the points in this platform to match the order in the data table?

 

Best,

Jenna

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Dan_Obermiller
Staff Dan_Obermiller
Staff
Solution

Re: "Points Spread" Function: Order of Points

Created: Dec 17, 2018 02:49 PM  |  Last Modified: Dec 17, 2018 12:09 PM (3856 views)  |  Posted in reply to message from JMPJenna 12-17-2018

I never noticed how JMP spread the points evenly.

 

The ordering was likely just a convenient way to create the algorithm to create that spread. After all, the actual position along the x-axis within any group does not matter so any routine that does that is as valid as another. I could imagine it plots from highest row number first because it has to search through the data table to determine the number of observations in a group in order to spread EVENLY. You won't know that result until you hit the end of the table. Just a guess on my part.

 

Anyhow, one way to get the lowest row number to be plotted furthest to the left and the highest row number plotted furthest to the right, is to re-sort the data table. Create a new column, I will call it Row Number. Initialize it with the default sequence (which will just be a listing from 1 to the number of rows). Now sort your data table in descending order based on Row Number. Now make your plot and spread the points evenly.

 

I know the points are in reverse order of the data table again, but since you reversed your data table, it works.

Dan Obermiller

View solution in original post

1 REPLY 1
Dan_Obermiller
Staff Dan_Obermiller
Staff
Solution

Re: "Points Spread" Function: Order of Points

Created: Dec 17, 2018 02:49 PM  |  Last Modified: Dec 17, 2018 12:09 PM (3857 views)  |  Posted in reply to message from JMPJenna 12-17-2018

I never noticed how JMP spread the points evenly.

 

The ordering was likely just a convenient way to create the algorithm to create that spread. After all, the actual position along the x-axis within any group does not matter so any routine that does that is as valid as another. I could imagine it plots from highest row number first because it has to search through the data table to determine the number of observations in a group in order to spread EVENLY. You won't know that result until you hit the end of the table. Just a guess on my part.

 

Anyhow, one way to get the lowest row number to be plotted furthest to the left and the highest row number plotted furthest to the right, is to re-sort the data table. Create a new column, I will call it Row Number. Initialize it with the default sequence (which will just be a listing from 1 to the number of rows). Now sort your data table in descending order based on Row Number. Now make your plot and spread the points evenly.

 

I know the points are in reverse order of the data table again, but since you reversed your data table, it works.

Dan Obermiller