Question: 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

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 containing both stocks?

Month November October September August I Return -4.6% 0.1% MSFT Return 10.490 1 3 .690 -10.3% -13.8% -9.3% 5.5% 2.1% 73 .990 5.50 -4.4% May 0.7% 9.4% 2 March February -34%

Step by Step Solution

★★★★★

3.26 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

XOM MSFT Average Return 089 114 Variance 165299 1482071 Standard devia... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

433-B-A-I (5761).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Spreadsheets are especially useful for computing stock value under different assumptions. Consider a firm that is expected to pay the following dividends: and grow at 5 percent thereafter A. Using an...

These data give monthly returns for stocks of three familiar companies: Disney, Exxon, and McDonalds from January 1990 through December 2005. (a) Describe and contrast histograms of the three...

Compute the standard deviation of Kohls monthly returns shown in Problem. In Problem, The past five monthly returns for Kohls are 4.11 percent, 3.62 percent, -1.68 percent, 9.25 percent, and -2.56...

I need these problems worked out because I can't grab the concept , is their any possible way it can be done in 5 hours please! I never had to use this extra feature up until now so I was wondering...

Month XOM Return MSFT Return November -3.70% 12% October 0.30% 16.30% September -2.10% -13.00% August -3.80% -18.30% July -4.60% -8.40% June -1.20% 4.50% May 0.40% 2.60% April 10.60% 26.80% March...

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...

A bondholder that owns a $1,000, 10%, 10-year bond has: Group ofanswer choices The right to receive $1,000 at maturity. 2 answers

please snswer the two questions. fill in the boxes. thumps up when both are answered. Spreadsheets are useful for computing statistics: averages, standard deviation, variance, and correlation are...

please answer both of them. thumps up later. thanks Spreadsheets are useful for computing statistics: averages, standard deviation, variance, and correlation are included as built-in functions. Below...

What is the difference between a problem and a symptom? Use an example to support your response.

Adams, Inc., is a book publisher that reissues old titles. The company offers these books with either a standard machine-glued hard cover or a deluxe, handembossed, hand-stitched, leather cover....

Sign test for the comparison of operators. The differences in the TBBMC measures in Exercise 7.39 can also be analyzed using a sign test. Set up the appropriate null and alternative hypotheses, carry...

Which of the following payout options for variable annuities would provide the largest monthly payment to annuitants? (A) Straight-life annuity (B) Life with period certain (C) Joint and survivor...

Why are there so many different types of international organizations in the financial institutions sector?

What are the principal goals of international banking regulation?

What were the key provisions of the U.S International Banking Act of 1978 and the International Lending and Supervision Act of 1983?

An investment will pay $500 in three years, $700 in five years and $1000 in nine years. If your discount rate is 6%, what is the present value of this investment? (Round to the nearest dollar) 4....

Nico Corporation expects to generate Iren cash flows of $200,000 per year for the next five years, Beyond that time, tree cash flows are expected to grow at a constant rate of ft percent per year...

A and B are partners sharing profits in the ratio of 3:1. On 1st April,2001, they admit C into partnership for 1/5 who pays Rs.50,000 as premium privately. On 1st April 2002,they admit D into...