Stock market analysts are continually looking for reliable predictors of stock

prices. Consider the problem of modeling the price per share of electric utility stocks

$($Y$).$ Two variables thought to influence this stock price are return on average equity

$(x_1)$ and annual dividend rate $(x_2).$ The stock price, returns on equity, and

dividend rates on a randomly selected day for several electric utility stocks are

provided in the file P$10\_19.$xlsx$.$

a$.$ Estimate a multiple regression equation using the given data. Interpret each of

the estimated regression coefficients.

b$.$ Interpret the standard error of estimate $s_e,R^2,$ and the adjusted $R^2.$ Does it

appear that predictions of price from this equation will be very accurate?