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 ...
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?
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 ...