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
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
Finding a professional expert in "partial differential equations" in the advanced level is difficult.
You can find this expert in "Assignmentexpert.com" with confidence.
Exceptional experts! I appreciate your help. God bless you!
Comments
Leave a comment