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
EugeneB
EugeneB
Level III

Find columns similar to test column (one by many correlation)

Created: Jan 16, 2021 01:47 PM  |  Last Modified: Jun 8, 2023 5:27 PM (911 views)

With 20,000 columns of continuous data, correlation of all by all is undesirable.  How to calculate correlation of all columns vs one column (many to one)?  to find similar columns.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User txnelson
Super User
Solution

Re: Find columns similar to test column (one by many correlation)

Jan 16, 2021 01:57 PM (907 views)  |  Posted in reply to message from EugeneB 01-16-2021

You can get what you need by using Response Screening

     Analyze=>Screening=>Response Screening

Place your 20,000 rows in the Y Response and your single comparison column in the X

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User txnelson
Super User
Solution

Re: Find columns similar to test column (one by many correlation)

Jan 16, 2021 01:57 PM (908 views)  |  Posted in reply to message from EugeneB 01-16-2021

You can get what you need by using Response Screening

     Analyze=>Screening=>Response Screening

Place your 20,000 rows in the Y Response and your single comparison column in the X

Jim
EugeneB
EugeneB
Level III

Re: Find columns similar to test column (one by many correlation)

Jan 16, 2021 02:06 PM (905 views)  |  Posted in reply to message from txnelson 01-16-2021
Excellent. Thx for quick response!
0 Kudos