1. Choose any US stock (besides Microsoft) and download to Excel its historic weekly prices over the last 6 years. Then do the same for the S&P500. Use Excel (you can have a look on the Microsoft file that I uploaded to Canvas): a. Calculate the stock and S&P500 average return. b. Calculate the stock and S&P500 standard deviation. c. Calculate the covariance between the stock and S&P500. d. Calculate the correlation between the stock and S&P500. e. Run a regression to estimate the beta of the stock, its alpha and the R-squared (copy and paste your regression output to the answers sheet). f. Is the beta coefficient significant? Is the alpha coefficient significant? Discuss your results