Table Use the data given to calculate annual retums 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 2012 data) Data as given in the problem are shown below Landry Incorporated Stock Price Market Index Dividend Includes Divs Goodman industries Year 2018 Stock Price Dividend $25.68 $1.73 $73.13 $4.50 1749557 2017 $22.13 $1.59 $78.45 $4.35 13.178.56 114 2016 $24.75 $1.50 $73.13 $4.13 13.01997 2015 $16.13 $1.43 $85.88 53.75 9,651.05 2014 $17.06 $1.35 $90.00 $3.38 2013 $11.44 $1.28 $83.63 $3.00 8.403.42 7.058.96 Table Options Title Caption We now calculate the rates of return for the two companies and the index 2018 2017 124] 2016 2015 2014 27 Goodman Landry Index Call Twat Ar Table Styles Headers & Footer 00 Rows Columns 26 Average 20 Note: To get the average, you could get the column sum and divide by 5, but you could also use the function wizard, Click tx, 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 Table Font Size Table Outline 12 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) 37 Use the function wizard to calculate the standard deviations Standard deviation of retums Goodman Landry Index Table Table Styles c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the Markat Index's returns on the horizontal axis. tis easiest to make scatter diagrams with a data set that has the X-axis variable in the left column, so we relamat the retums data calculated above and show it just below Table Options Title Caption Year Index Goodman Landry 2018 0.0% 0.0% 0.0% 2017 0.0% 0.0% 0.0% 2016 0.0% 0.0% 0.0% 2015 0.0% 0.0% 0.0% 2014 0.0% 0.0% 0.0% Headers & Footer Rows Colum Table Font Size Table Outline Henry's ume.docx C et timing Outline Table Title