Hypothesis Tests for the Regression Coefficients ;Regression Assumptions (Model Assumptions)
HW-8
Bus 310-011
Due Date: 11:59 pm Apr 25
Total points: 18
For this assignment, submit 2 Excel files. Save the file P02_11.xlsx as HW-8_Bus 310_your last name_Question 1. Save the file Dataset_stock prices.xlsx as HW-8_Bus 310_your last name_Question 2.
1. The file P02_11.xlsx contains the selling prices (Y) and the appraised values (X) of the 148 homes.
a) Construct a 95% confidence interval for the average value of y. Use x = 130,000.
b) Construct a 95% prediction interval for a single value of y. Use x = 130,000.
c) Compare the results.
2. 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 ( and annual dividend rate (. The stock price, returns on equity, and dividend rates on a randomly selected day for several electric utility stocks are provided in the file Dataset_stock prices.xlsx sheet named Data.
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 t 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 α = 0.05.
c) Comment on the overall strength of the regression model in light of, R2, and adjusted R2.
[4 + 4 + 4 = 12]