Simple linear regression model
Data for the sample of houses sold recently in suburb of large metropolis are given below:
|Area of House (hundreds of square feet)
||Selling Price (thousands of dollars)
(a) Do scatter diagram for data, insert trend line and add the equation and R2 value to diagram.
(b) Find out SSxx, SSyy and SSxy.
(c) Find out the regression equation manually. Compare with equation obtained when doing scatter diagram.
(d) Now, produce regression report. Compare the equation from regression report with equation obtained manually and while doing scatter plot.
(e) Find out SSyy, SSR, SSE.
(f) Find out the degrees of freedom associated with the sum of squares in part (a).
(g) Find out MSR and MSE.
(h) Summarize your findings as ANOVA table.
(i) Find out the coefficient of determination R2.
(j) Find out standard error of estimate se
(k) Test the hypothesis that Y and X aren't related. That is, test H0: b1 = 0 vs. H1: b1 ¹ 0 by using the t-statistic. Employ a = 0.05.
(l) Find out the predicted value of Y given X = 24. Give the interpretation of predicted value in context of the problem.
(m) Find out 95 % confidence interval for mean value of Y given X = 24. Give interpretation of confidence interval in the context of problem.