EXCEL Spreadsheets are useful for computing statistics: averages,
standard deviation, variance, and correlation are included as
built-in functions. Below is recent monthly stock return data for
ExxonMobil (XOM) and Microsoft (MSFT). Using a spreadsheet
and its functions, compute the average, variance, standard deviation,
and correlation between the returns for these stocks. What
does the correlation between the returns imply for a portfolio
containing both stocks? MONTH XOM RETURN MSFT RETURN
November 4.6% 10.4%
October 0.1% 13.6%
September 1.9% 10.3%
August 3.3% 13.8%
July 4.4% 9.3%
June 1.6% 5.5%
May 0.7% 2.1%
April 9.4% 23.9%
March 0.1% 7.3%
February 3.2% 3.4%
1
Expert's answer
2013-12-18T10:25:27-0500
Dear visitor Unfortunately, your question requires a lot of work and cannot be done for free. Please submit it with all requirements as an assignment to our control panel and we’ll assist you
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
Comments
Leave a comment