a$.$ Estimate the CAPM beta for Boeing using regression analysis. Present the regression results with statistics. $($Do one of the two options

Option $1$: Use the "Data Analysis" tool. On the Data tab, select Data Analysis, and then Regression. Enter y$\text{'}$s $($B$9$:B$68)$ and x$\text{'}$s $($C$9$:C$68)$ to

run the regression.

Option $2$: Use the LINEST$()$ functin. Select cell B$95,$ go to Formulas rarr More Functions rarr$->$ Statistical, select LINEST function. You could

click "Help on this function" at the left lower comer for help.

Estimates

b$.$ Given risk free rate $=4\mathrm{.}50\%$ and market risk premium $=7\mathrm{.}50\%,$ estimate the cost of equity of Boeing.

please use excel and show cell reference. its urgent need help as soon as possible. thank you so much.