Question: Please show all excel formulas and/or functions to complete this question. Stock A and Stock B prices and dividends, along with the Market Index, are

 Please show all excel formulas and/or functions to complete this question.

Please show all excel formulas and/or functions to complete this question.

Stock A and Stock B prices and dividends, along with the Market Index, are shown below. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. Stock A: Stock Price $25.88 $22.93 $24.75 $16.13 $17.16 $11.44 Stock B: Stock Price $73.13 $78.45 $73.13 $85.88 90.00 $86.33 Market Index 2016 2015 2014 2013 2012 2011 Dividend $1.73 $1.59 $1.50 $1.43 $1.35 $1.28 Dividend $4.50 $4.35 $4.13 $3.75 $3.38 $3.00 $17.09 $13.27 $13.01 $9.96 $8.40 $7.05 Calculate the standard deviations of the returns for Stock A, Stock B, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!