Data for a sample of houses sold recently in the suburb of a large metropolis - 25372

Solution Posted by
SuperPower

SuperPower

Rating : (21)A
Solution Detail
Price: $6.99
  • From: Mathematics,
  • Posted on: Wed 18 Sep, 2013
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

Notes: Before doing this assignment, do the practice problem posted under Apply and Discover. Use the instructions given in the document “Using Excel for Regression Analysis” for doing scatter plot, inserting the trend line and producing the regression report using the data analysis regression tool. Copy and paste the scatter plot and the regression report from Excel into this document.Show all steps

 

Problem

Data for a sample of houses sold recently in the suburb of a large metropolis are given below:

 

Area of House (hundreds of square feet)

Selling Price (thousands of dollars)

20

250

19

220

27

350

28

390

30

320

15

200

25

360

23

290

18

210

35

410

(a)    Do a scatter diagram for the data, insert the trend line and add the equation and R2 value to the diagram.

(b)   Find SSxx, SSyy and SSxy.

(c)    Determine the correlation coefficient. Comment on the value of the correlation coefficient.

(d)   Find the regression equation  manually. Compare with the equation obtained when doing the scatter diagram.

(e)   Find SST, SSR and SSE.

(f)     Find the degrees of freedom associated with the sum of squares in part (e).

(g)    Find MSR and MSE.

(h)   Summarize your findings as an ANOVA table.

(i)      Find the coefficient of determination R2.

(j)     Find standard error of the estimate se

(k)    Test the hypothesis that Y and X are not related. That is, test H0: b1 = 0 vs. H1: b1 ¹ 0 by using a t-statistic. Use a = 0.05.

(l)      Find the predicted value of Y given X = 24. Give an interpretation of the predicted value in the context of the problem.

(m)  Find a 95% confidence interval for the mean value of Y given X = 24. Give an interpretation of the confidence interval in the context of the problem.

Solution Description

Previously, thank you for purchasing my tutorial. I try to

Attachments
Linear Regression (All Questions Answered + Formulas).xls
Linear Regressi...
Linear Regression (All Questions Answered in Detail).doc
Linear Regressi...