What does the correlation between the returns imply

Reference no: EM13294500

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?

Reference no: EM13294500

Questions Cloud

Risk-free interest rate r : Suppose an individual lives two periods. In period 1 she works full time and makes $100. In period 2 she enters partial retirement and makes $20. She can borrow and save at the constant, risk-free interest rate r.

Does it make economic sense to quit your job to do an mba : The MBA program is a full-time two year program with tuition and fees of $20,000 per yera. Your personal discount rate is 8%. Does it make economic sense to quit your job to do an MBA?

Find the probability of encountering a white ball : A box contains 'm' white balls and 'n' black balls.Balls aredrawn at random one at a time without replacement. Find the probability of encountering a white ball by the kth draw.

How far did the last car travel : A train is traveling up a 5.0 degrees incline at a speed of 2.65 m/s when the last car breaks free and begins to coast without friction. How far did the last car travel before momentarily coming to rest

What does the correlation between the returns imply : 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?

How much charge is transported as a result of the charging : A constant current of 3 A for 4 hours is required to charge an automotive battery. If the terminal voltage is 10+ t/2 ,where t is in hours, a) How much charge is transported as a result of the charging

Explain what mass of melamine c3n3(nh2)3 of urea : What mass of melamine, C3N3(NH2)3 will be obtained from 178.5 kg of urea, CO(NH2)2 if the yield overall reaction is 83.0%

A product falls at the same time supply rises : If demand for a product falls at the same time supply rises, which of the following might we expect?

Find the drift speed in the electron beam : a 100mA current flows through a copper wire 0.10mm in diameter, a 1.0mm diameter glass tube containing a salt solution, and a vacuum tube, Find the drift speed in the electron beam

User Account

All Pages