Expected return, standard deviation, and covariance in Excel / Principles of finance / Episode 6

We demonstrate how you can use Excel to compute expected return, standard deviation, covariance, and correlation for risky assets such as stocks.

You can download the spreadsheet used in this tutorial here:
www.initialreturn.com/expected-return-standard-dev…

00:00 Intro
00:32 Step 1: Prepare the inputs
02:31 Step 2: Expected return
03:54 Step 3: Variance & standard deviation
08:12 Step 4: Covariance
10:08 Step 5: Correlation

Enjoying our content?

Click the link below to subscribe to our channel:
   / @initialreturn  

You can also follow us on Twitter:
twitter.com/initial_return

And, visit our website for free courses, tutorials, and more:
www.initialreturn.com/

#investing #exceltutorial #finance101