The attached file contains hypothetical data for working this problem. Goodman Corporation's and Landry Incorporated's stock prices and dividends, along with the Market Index, are shown in the file. 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.

Data as given in the problem are shown below:

Goodman Industries

Landry Incorporated

Market Index

Year

Stock Price

Dividend

Stock Price

Dividend

Includes Divs.

2020

$30.32

$2.23

$85.12

$3.52

18,475.97

2019

$23.53

$2.65

$79.32

$3.65

12,174.55

2018

$28.61

$2.73

$74.32

$3.45

12,019.97

2017

$15.21

$2.57

$87.12

$3.47

10,743.05

2016

$12.63

$2.23

$95.12

$3.55

9,455.42

2015

$13.21

$2.25

$84.25

$3.25

8,163.96

a.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.

b.Estimate Goodman's and Landry's betas as the slopes of regression lines with stock returns on the vertical axis (y-axis) and market return on the horizontal axis (x-axis).(Hint: use Excel's SLOPE function.)Are these betas consistent with your graph?

need step by step procedure rather than just answers