Please only use excel formulas and show them so I can understand. For part A, calculate the rates of return for Goodman, Landry, and the Index for years 2013-2018. For B, use the function wizard to calculate the standard deviation. Thank you!

a. Use the data given to calculate annual returns for Goodman, Landry, and the Market Index, and then calculate average returns over the five-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the index. Also, you cannot calculate the rate of return for 2013 because you do not have 2002 data.) Data as given in the problem are shown below Goodman Industries ated Market Index Dividend Includes Divs an Year 2018 2017 2016 Stock Price $25.88 $22.13 $24.75 $16.13 $17.06 $11.44 Dividend $1.73 $1.59 $1.50 $1.43 $1.35 $1.28 Stock Price $73.13 $78.45 $73.13 $85.88 $90.00 $83.63 $4.50 $4.35 $4.13 $3.75 $3.38 $3.00 17,495.97 13,178.55 13,019.97 9,651.05 8,403.42 7.058.96 2014 2013 We now calculate the rates of return for the two companies and the index Goodman an Index 2018 2017 2016 2014 Average Note: To get the average, you could get the column sum and divide by 5, but you could also use the function wizard, b. Click fx, then statistical, then Average, and then use the mouse to select the proper range. Do this for Goodman and then copy the cell for the other items b. Calculate the standard deviation of the returns for Goodman, Landry, and the Market Index. (Hint: Use the sample standard deviation formula given in the chapter, which corresponds to the STDEV function in Excel.) Use the function wizard to calculate the standard deviations Goodman an Index Standard deviation of returns On a stand-alone basis, it would appear that Goodman is the most risky, Landry the least risky