Question

MC Qu. 82 RedStone Mines stock returned... RedStone Mines stock returned 7.5, 15.3,-9.2, and 11.5 percent over the past four years, respectively. What is the geometric average return? 5.84 percent 6.36 percent 775 percent 9.94 percent 10.33 percent4 value: 1.00 points MC Qu. 69 Over the past four years... Over the past four years, a stock produced returns of 13, 6,-5, and 18 percent, respectively. What is the standard deviation of these returns? 8.63 percent O 9.93 percent 9.97 percent 10.11 percent 10.15 percent

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard CD117 BU Alignment Number Cells BV BW BX BY BZ CA CD CE CG 116 YEAR return ADD 100 IN RETURN 7.5 15.3 9.2 11.5 107.5 115.3 90.8 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 4 PV FV DIVIDEND 4 EXCEL 5.84 GEOMEAN(BX117:BX120) -100 GEOMTRIC AVERAGE ANSWER 5.84% YEAR return 13 6 4 18 EXCEL STANDARD DEVIATION 9.97 STDEV.S(BW127:BW130) ANSWER 9.97% EMV MEAN STDV DEAR (Sheet2 | COV TIME SERIES corr REGRESSION CAMERAEXP RETURN MATRIX INTERVAL, NORMAL HYİ 福 130% 21-01-2019

Add a comment
Know the answer?
Add Answer to:
MC Qu. 82 RedStone Mines stock returned... RedStone Mines stock returned 7.5, 15.3,-9.2, and 11.5 percent...
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
  • Green stock returned 6 percent, -8 percent, 14 percent, and 16 percent over the past four...

    Green stock returned 6 percent, -8 percent, 14 percent, and 16 percent over the past four years, respectively. What is the arithmetic average return for this period? 6.11 percent 7.00 percent 10.19 percent 12.42 percent A stock has an average return of 12.5 percent and a standard deviation of 4.3 percent. What range of returns would you expect to see 99 percent of the time on this security? -4.7 percent to 29.7 percent -0.4 percent to 25.4 percent 8.2 percent...

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