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 (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for several electric utility stocks are provided below. a. Use Excel to develop the equation of the regression model. Comment on the regression coefficients. Determine the predicted value of y for x1=12.1 and x2 = 3.18
b. Study the ANOVA table and the ratios and use these to discuss the strengths of the regression model and the predictors. Does this model appear to fit the data well? Use alpha = 0.05.
c. Comments on the overall strength of the regression model in light of se, R2, and adjusted R2.

Electric Utility Stock Price Return Average Equity Annual Dividend Rate
1 $23 13.7 2.36
2 $34 12.8 3.12
3 $20 6.9 2.48
4 $24 12.7 2.36
5 $20 15.3 1.92

need more information

step-by-step explanation:

step-by-step explanation:

i found the life tables for the year 2012. 

life table of males at age 30. probability of dying between ages x and x+1

total population:  

29–30 . . . . . . . . . . . . 0.001030

30–31 . . . . . . . . . . . . 0.001061

males:  

29–30 . . . . . . . . . . . . 0.001420

30–31 . . . . . . . . . . . . 0.001448

white population

29–30 . . . . . . . . . . . . 0.001005

30–31 . . . . . . . . . . . . 0.001037

white males

29–30 . . . . . . . . . . . . 0.001372

30–31 . . . . . . . . . . . . 0.001399

non hispanic white population

29–30 . . . . . . . . . . . . 0.001083

30–31 . . . . . . . . . . . . 0.001116

non hispanic white males

29–30 . . . . . . . . . . . . 0.001477

30–31 . . . . . . . . . . . . 0.001503

jacob, non hispanic white male. 30 years old.

probability that jacob lives to be 30 years old. 

since the given probabilities are probabilities of dying, i think we simply subtract it from 1 to get the probability of living. we will use the probability of non hispanic white male.

                                          probability of living to be 30 y.o.

29 - 30 : 1 - 0.001477 = 0.998523

30 - 31 : 1 - 0.001503 = 0.998497

yes.. it's proven to be 36.