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

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

EugeneB — Fri, 09 Jun 2023 00:27:38 GMT

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.

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

txnelson — Sat, 16 Jan 2021 18:57:53 GMT

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

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

EugeneB — Sat, 16 Jan 2021 19:06:58 GMT

Excellent. Thx for quick response!