Question

FIN 344 Test: Ch 5-6 3. Over the past four days, Stock X had returns of 3, 1,-3, -2, and 1 percent. At the same t had returns of 2A,-so, and-1. Treat the data as a sample. Compute and interpret the correlation coefficient of returns. Stock x 3 Stock Y 2 3 -5
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Hi,

Ive done the work in an excel, please have a look below. If you have any doubts please feel free to enter your questions in the comment section and I would clarify those for you.

Ans: Correlation coefficient = 0.789402522

Clipboard Font Alignment Number Styles B15 Stock Y- Stock X Mean Mean Stock X 3% 1% -3% -2% 1% Stock Y 2% 4% 5% 0% 1% X2 0.03

All excel formulas used:

Stock X - Mean Stock Y - Mean Stock X Stock Y X2 V2 (X*IY*) FA2-SC$9 A3-$C$9 A4-$C$9 A5-SC$9 A6-SC$9 B2-SC$10 C2A2 -C342 -84-

Have a good day!

Hit thumbs up if you find this useful

Add a comment
Know the answer?
Add Answer to:
FIN 344 Test: Ch 5-6 3. Over the past four days, Stock X had returns of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A stock had returns of 6 percent, 30 percent, and -9 percent over the past 3...

    A stock had returns of 6 percent, 30 percent, and -9 percent over the past 3 years. What is the mean of the stock’s returns over the past 3 years minus the sample standard deviation of the stock’s returns from the past 3 years? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

  • 5. Stock x, stock Y, and the market have had the following returns over the past...

    5. Stock x, stock Y, and the market have had the following returns over the past four years. х Y Market 11% Year 1999 2000 2001 2002 10% 4% 7% 12% -3% 21% -5% 17% 12% -3% -2% The risk-free rate is 7 percent. The market risk premium is 5 percent. What is the required rate of return for a portfolio that consists of $14,000 invested in Stock X and $6,000 invested in Stock y rates of return?

  • A stock had returns of 18 percent, 33 percent, and -3 percent over the past 3...

    A stock had returns of 18 percent, 33 percent, and -3 percent over the past 3 years. What is the mean of the stock’s returns over the past 3 years minus the sample standard deviation of the stock’s returns from the past 3 years? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

  • A stock had returns of 18 percent, 27 percent, and -12 percent over the past 3...

    A stock had returns of 18 percent, 27 percent, and -12 percent over the past 3 years. What is the mean of the stock’s returns over the past 3 years minus the sample standard deviation of the stock’s returns from the past 3 years? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

  • Stock X and the "market" have had the following rates of returns over the past four...

    Stock X and the "market" have had the following rates of returns over the past four years. Year 1 Stock X 12.00% 5.00% 11.00% 2 Market 13.80% 1.65% 13.70% -2.7296 3 4 -7.00% 62% of your portfolio is invested in Stock X and the remaining 38% is invested in Stock Y. The risk-free rate is 5.24% and the market risk premium is also 5.24%. You estimate that 14.11% is the required rate of return on your portfolio. What is the...

  • A stock had returns of 8%, -2%, 4%, and 16% over the past four years.

    A stock had returns of 8%, -2%, 4%, and 16% over the past four years. What is the standard deviation of this stock for the past four years? 7.1% 7.5% 6.3%  6.6%  

  • A stock had returns of 6 percent, -2 percent, 2 percent, and 16 percent over the...

    A stock had returns of 6 percent, -2 percent, 2 percent, and 16 percent over the past four years. What is the standard deviation of these returns? 0 6.8 percent O 8.1 percent O 7.3 percent O 7.7 percent O 6.4 percent

  • A stock had returns of 16.94 percent (1 year ago), -27.01 percent (2 years ago), X...

    A stock had returns of 16.94 percent (1 year ago), -27.01 percent (2 years ago), X (3 years ago), and 22.33 percent (4 years ago) in each of the past 4 years. Over the past 4 years, the arithmetic average annual return for the stock was 10.75 percent. What was the geometric average annual return for the stock over the past 4 years? Answer as a rate in decimal format so that 12.34% would be entered as 1234 and 0.98%...

  • A stock had returns of 16.27 percent, 24.18 percent, −12.29 percent, and 9.62 percent over four...

    A stock had returns of 16.27 percent, 24.18 percent, −12.29 percent, and 9.62 percent over four of the past five years. The arithmetic average return over the five years was 13.28 percent. What was the stock return for the missing year? 25.76% 15.34% 28.62% 4.04% 22.90%

  • - Question 3 1 point Number Help A stock had returns of 14.94 percent (1 year...

    - Question 3 1 point Number Help A stock had returns of 14.94 percent (1 year ago), -25.67 percent (2 years ago), X (3 years ago), and 26.71 percent (4 years ago) in each of the past 4 years. Over the past 4 years, the geometric average annual return for the stock was 6.68 percent. What was the arithmetic average annual return for the stock over the past 4 years? Answer as a rate in decimal format so that 12.34%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT