Download the monthly adjusted closing prices for the five stocks for the period December 31, 2014 December 31, 2019 into a spreadsheet from Yahoo or Google. Do the same for the S&P 500 index. Calculate the return for each month for each of these six assets.

Calculate the following for each asset (in Excel, using the statistical functions given in parentheses): average return (AVERAGE), standard deviation of returns (STDEV), and variance of returns (VAR). What is the covariance (COVAR) and correlation (CORREL) between the returns of stock 1 and stock 2? Stock 1 and stock 3? Stock 1 and stock 4 etc.? Calculate the correlation and covariance for each pair of your stocks.

The assets are AMZN, GOOGL, ZM, AAPL, SNAP. S&P 500 index