I have 4 columns of data, 2000 rows long.
Column A is Factor 1
Column B is Factor 2
Column C is Factor 3
Column D is the Dependent Varible
There is significant ranked correlation between Factor 1 and 4, Factor 2 and 4, and Factor 3 and 4. Each Column of data distributions are not normal...hence converting the data to rank data and then calculating Spearman's Rho.
Is there a way (via Excel) to calculate a weighted average using Factors 1,2, and 3 that would maxamize the spearman's correlation with respect to the dependent varible? i.e. ((factor1).4)+((factor2)*.2)+((Factor3)*.4) = the highest spearman's correlation to dependent variable?
Thx,
J
Column A is Factor 1
Column B is Factor 2
Column C is Factor 3
Column D is the Dependent Varible
There is significant ranked correlation between Factor 1 and 4, Factor 2 and 4, and Factor 3 and 4. Each Column of data distributions are not normal...hence converting the data to rank data and then calculating Spearman's Rho.
Is there a way (via Excel) to calculate a weighted average using Factors 1,2, and 3 that would maxamize the spearman's correlation with respect to the dependent varible? i.e. ((factor1).4)+((factor2)*.2)+((Factor3)*.4) = the highest spearman's correlation to dependent variable?
Thx,
J