i need help guys

B D E G 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 Landry Index Standard deviation of retums c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the Market Index's returns on the horizontal axis. It is easiest to make scatter diagrams with a data set that has the X-axis variable in the left column so we refomat the retums data calculated above and show it just below. Year 2019 2018 2017 2016 2015 Index 33.0% 1.0% 36.0% 15.0% 19.0% Goodman 25.0% -4.0% 63.0% 3.0% 61.0% Landry 6.0% 6.0% 5.0% 4.0% 4,0% 3 5 6 To make the graph, we first selected the range with the retums and the column heads, then clicked the chart wizard, 7 then choose the scatter diagram without connected lines. That gave us the data points. We then used the drawing 8 toolbar to make free-hand ("by eye") regression lines, and changed the lines color and weights to match the dots. a B D E G 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 Landry Index Standard deviation of retums c. Construct a scatter diagram graph that shows Goodman's and Landry' returns on the vertical axis and the Market Index's returns on the horizontal axis. It is easiest to make scatter diagrams with a data set that has the X-axis variable in the left column so we refomat the retums data calculated above and show it just below. Year 2019 2018 2017 2016 2015 Index 33.0% 1.0% 36.0% 15.0% 19.0% Goodman 25.0% -4.0% 63.0% 3.0% 61.0% Landry 6.0% 6.0% 5.0% 4.0% 4,0% 3 5 6 To make the graph, we first selected the range with the retums and the column heads, then clicked the chart wizard, 7 then choose the scatter diagram without connected lines. That gave us the data points. We then used the drawing 8 toolbar to make free-hand ("by eye") regression lines, and changed the lines color and weights to match the dots. a