subject
Mathematics, 26.10.2021 14:00 paulinahunl17

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

ansver
Answers: 1

Another question on Mathematics

question
Mathematics, 21.06.2019 18:40
Aportion of a hiking trail slopes downward at about an 84Β° angle. to the nearest tenth of a flot, what is the value of x, the distance the hiker traveled along the path, if he has traveled a horizontal distance of 120 feet? a. 143.3 b. 12.5 c. 120.7 d. 130.2
Answers: 1
question
Mathematics, 21.06.2019 22:30
Consider an example of a deck of 52 cards: example set of 52 playing cards: 13 of each suit clubs, diamonds, hearts, and spades ace 2 3 4 5 6 7 8 9 10 jack queen king clubs diamonds hearts spades what is the probability of drawing three queens from a standard deck of cards, given that the first card drawn was a queen? assume that the cards are not replaced.
Answers: 1
question
Mathematics, 22.06.2019 02:00
How many square inches are in 60 square feet?
Answers: 1
question
Mathematics, 22.06.2019 02:30
Solve the compound inequality. graph your solution. 2x – 2 < –12 or 2x + 3 > 7 x < –5 or x > 5 x < –5 or x > 2 x < –12 or x > 2 x < –7 or x > 5
Answers: 2
You know the right answer?
Stock market analysts are continually looking for reliable predictors of stock prices. Consider the...
Questions
question
Mathematics, 30.12.2020 21:30
question
Mathematics, 30.12.2020 21:30
question
Mathematics, 30.12.2020 21:30
question
Computers and Technology, 30.12.2020 21:40
question
Mathematics, 30.12.2020 21:40
question
Computers and Technology, 30.12.2020 21:40
Questions on the website: 13722366