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

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₁) and annual dividend rate (X₂). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P16_15.xlsx. Estimate a multiple regression model using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.