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: 
Check out the JMP® Marketplace featured Capability Explorer add-in
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 (864 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 (860 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 (861 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 (858 views)  |  Posted in reply to message from txnelson 01-16-2021
Excellent. Thx for quick response!
0 Kudos