Question

Problem 9. (6 pts] Wells Fargo, Netflix, RBC (U:RY) stocks have the following annual returns from the year 2011 to 2018. (Show your calculations) Stocks>> Wells FargoNetflix RBC (U:RY) 2011 2012 2013 2014 2015 2016 2017 2018 0.170 0.127 0.240 0.328 0.207 -0.008 0.014 0.101 2.239 0.612 0.336 2.976 -0.072 1.344 0.082 0.551 0.014 -0.035 0.183 0.115 0.027 -0.224 0.264 0.206 Source: Thomson Reuters Datastream. Note. All figures are in three decimal places. Using the data in the table above, complete the following questions: a. Compute the correlation coefficient between Netflix and Wells Fargo retums (round to 2 decimal places) b. Compute the correlation coefficient between Netflix and RBC returns (round to 2 decimal places) c Compute the correlation coefficient between Wells Fargo and RBC returns (round to 2 decimal places)
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE SCREENSHOT. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE. THANK YOU.

AS NOTHING WAS MENTIONED, I HAVE USED EXCEL. IF YOU NEED WITH FORMULA, LET ME KNOW, WILL DO THAT AS WELL. HAPPY TO HELP YOU

146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 WELLS FARGO NETFLIX RBC YEAR 0.17 2.239-0.014 2-0.127-0.612-0.035 0.240.3360.183 4 0.3282.9760.115 5 0.207 -0.0720.027 6-0008 1.344-0.224 7 0.014 0.0820.264 80.101 0.551 0.206 3 CORRELATION COSEEFICIENT BETWEEN NETFLIX & WELLS FARGO NETFLIX & RBC WELLS FARGO & RBC 0.59 0.16 0.33 CORREL(P149:P156,Q149:Q156) CORREL(Q149:0156,R149:R156) CORREL(P149 P156,R149:R156)

Add a comment
Know the answer?
Add Answer to:
Problem 9. (6 pts] Wells Fargo, Netflix, RBC (U:RY) stocks have the following annual returns from...
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
  • Problem 9·(6 pts Wells Fargo, Netflix, RBC (U:RY) stocks have the following annual returns from the...

    Problem 9·(6 pts Wells Fargo, Netflix, RBC (U:RY) stocks have the following annual returns from the year 2011 to 2018. (Show vour calculations) Stocks>> Wells Fargo Netflix RBC (U:RY) 2011 2012 2013 2014 2015 2016 2017 2018 0.170 0.127 0.240 0.328 0.207 -0.008 0.014 0.101 2.239 0.612 0.336 2.976 -0.072 1.344 0.082 0.551 0.014 0.035 0.183 0.115 0.027 -0.224 0.264 0.206 Source: Thomson Reuters Datastream. Note. All figures are in three decimal places. Using the data in the table above,...

  • Problem 2. 16 pts] Wells Fargo, Netflix, RBC (U:RY) stocks have the following annual returns from...

    Problem 2. 16 pts] Wells Fargo, Netflix, RBC (U:RY) stocks have the following annual returns from the year 2011 to 2018. (Show vour calculations) Stocks>> Wells Fargo Netflix RBC (U:RY) 2011 2012 2013 2014 2015 2016 2017 2018 0.170 0.127 0.240 0.328 0.207 0.008 0.014 0.101 2.239 0.612 0.336 2.976 -0.072 1.344 0.082 0.551 0.014 0.035 0.183 0.115 0.027 0.224 0.264 0.206 Source: Thomson Reuters Datastream. Note. All figures are in three decimal places. Using the data in the table...

  • Problem 8-6 Expected returns Stocks A and B have the following probability distributions of expected future returns: Pr...

    Problem 8-6 Expected returns Stocks A and B have the following probability distributions of expected future returns: Probability -20% 0.2 0.2 a. Calculate the expected rate of return, rb, for Stock B (rA = 14.50%.) Do not round intermediate calculations. Round your answer to two decimal places. b. Calculate the standard deviation of expected returns, OA, for Stock A (OB = 20.06%.) Do not round intermediate calculations. Round your answer to two decimal places. C. Now calculate the coefficient of...

  • Problem 9-33 Risk, Return, and Their Relationship (LG9-3, LG9-4) Consider the following annual returns of Estée...

    Problem 9-33 Risk, Return, and Their Relationship (LG9-3, LG9-4) Consider the following annual returns of Estée Lauder and Lowe's Companies: Year 1 Year 2 Year 3 Year 4 Year 5 Estée Lauder 23.48 -26.0 17.6 49.9 -16.8 Lowe's Companies -6.08 16.1 4.2 48.0 - 19.0 Compute each stock's average return, standard deviation, and coefficient of variation (Round your answers to 2 decimal places.) Estée Lauder Lowe's Companies Average return Standard deviation Coefficient of variation Which stock appears better? Rank the...

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