Question

PROBLEM 5 – HOUSING PRICES

Situation:

Real Estate One conducted a recent survey of house prices for properties located on the shores of Tawas Bay. Data on 26 recent sales, including the number of bathroom, square feet and bedrooms are below.

Selling Price	Baths	Sq Ft	Beds
160000	1.5	1776	3
170000	2	1768	3
178000	1	1219	3
182500	1	1568	2
195100	1.5	1125	3
212500	2	1196	2
245900	2	2128	3
250000	3	1280	3
255000	2	1596	3
258000	3.5	2374	4
267000	2.5	2439	3
268000	2	1470	4
275000	2	1678	4
295000	2.5	1860	3
325000	3	2056	4
325000	3.5	2776	4
328400	2	1408	4
331000	1.5	1972	3
344500	2.5	1736	3
365000	2.5	1990	4
385000	2.5	3640	4
395000	2.5	1918	4
399000	2	2108	3
430000	2	2462	4
430000	2	2615	4
454000	3.5	3700	4

Action:

Use the data above and multiple regression to produce a model to predict the average sale price from other variables. Comment on the following:

a. Regression equation

b. R, R2 and 1-R2, adjusted R2

c. Standard error of estimate

d. Report the t's for each value and the corresponding p-values

e. Overall test of hypothesis and decision

f. Use a .05 level of significance. Cite which variables are significant and which are not significant, based on the t values and p values for each independent variable.

Answer 1