cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

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

EugeneB
EugeneB
Level III
Created: Jan 16, 2021 01:47 PM  |  Last Modified: Jun 8, 2023 5:27 PM 1039 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 (1035 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 (1036 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 (1033 views)  |  Posted in reply to message from txnelson 01-16-2021
Excellent. Thx for quick response!
0 Kudos

Recommended Articles