Tagged Questions

1
vote
1answer
51 views

Calculating the corr. coefficient between returns of portfolios in EXCEL

I want to determine the correlation between the returns of a portfolio with returns of the market (suitable index). To find how the portfolio performs in bear resp. bull markets, I want to calculate ...
1
vote
1answer
142 views

Correlation coefficient of two variables with unequal number of data using Excel

How do I find the correlation coefficient of two variables with unequal number of data using Excel? And do I use the mean as data to calculate?
0
votes
1answer
216 views

How can I determine which columns best correlate with target column in a SQL Server Table?

I have a table with a couple hundred columns and a few hundred thousand rows and want to determine which combination of 5-10 columns best correlate with a target column. I have SQL Server and Excel ...