Beta is a measure of the volatility of a portfolio compared to the market as a whole. Beta can be calculated by taking the covariance of the portfolio’s returns and the market’s returns and dividing this by the variance of the market’s returns. The second way of calculating beta is by using a regression. In this video, we cover both methods and also interpret the meaning of the beta figure.
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/AMcPOD-MaN8
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Calculate Beta Using The Formula: (0:57)
Calculate Beta Using A Regression: (2:34)