Covariance Matrix - Excel and Finance
Covariance Matrix in Excel Before calculating a covariance matrix in Excel the Excel-Add-In Analysis-Functions need to be installed. After open the data tab and run Data-Analysis and Covariance-Matrix. Follow the steps in the video tutorial.
excelandfinance.com |