Correlation (Pearson) Explained with Excel Walkthrough

Pearsons Correlation coefficient is a useful concept to understand when seeking to determine whether assets behave jointly. Pearsons correlation coefficient assumes that the joint probability distribution of assets returns follows a bivariate normal distribution (when comparing two assets). Even though this has its pitfalls when it comes to financial time series analysis, it serves as a great way to learn about math notation for mean, variance, covariance and correlation.

This correlation coefficient measure is likely also the most commonly used, albeit the previously mentioned drawbacks.

We will lead on from this video to cover Kendalls Tau, Spearman's Rho, Copula dependency and more...

[jon-uk]

Excellent video as always, I have learned so mich over the last couple of years from your courses and YouTube videos.

[superpasi]

I am always so hyped when you upload a new video

[tigerlai]

I was super excited to see you release a new video, and I watched it as soon as I could. But I have a question. It has been half a year since I finished the statistical arbitrage course, and I haven’t made any profit after testing it for half a year. I think there is something wrong with the parameters I set. I wonder if you will update the course or release related videos in the future? Looking forward to it.