Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Home Price SqFt Bedrooms Bathrooms Offers Brick Neighborhood new brick Neighborhood (W) Neighborhood (E) 1 $553,500 1790 2 2 2 No North 0 0 0

Home Price SqFt Bedrooms Bathrooms Offers Brick Neighborhood new brick Neighborhood (W) Neighborhood (E)
1 $553,500 1790 2 2 2 No North 0 0 0
2 $572,000 2030 4 2 3 No East 0 1 0
3 $575,000 1740 3 2 1 Yes East 1 1 0
4 $474,500 1980 3 2 3 No East 0 1 0
5 $599,000 2130 3 3 3 No East 0 1 0
6 $573,000 1780 3 2 2 No North 0 0 0
7 $746,000 1830 3 3 3 Yes West 1 0 1
8 $751,500 2160 4 2 2 No West 0 0 1
9 $596,000 2110 4 2 3 No East 0 1 0
10 $520,000 1730 3 3 3 No East 0 1 0
11 $664,500 2030 3 2 3 Yes East 1 1 0
12 $620,000 1870 2 2 2 Yes East 1 1 0
13 $513,000 1910 3 2 4 No North 0 0 0
14 $632,500 2150 3 3 5 Yes North 1 0 0
15 $843,000 2590 4 3 4 No West 0 0 1
16 $716,000 1780 4 2 1 No West 0 0 1
17 $736,500 2190 3 3 4 Yes East 1 1 0
18 $418,000 1990 3 3 4 No North 0 0 0
19 $563,000 1700 2 2 1 Yes East 1 1 0
20 $817,000 1920 3 3 2 Yes West 1 0 1
21 $581,000 1790 3 2 3 No East 0 1 0
22 $569,000 2000 3 2 4 No North 0 0 0
23 $458,500 1690 3 2 3 No North 0 0 0
24 $535,500 1820 3 2 3 Yes North 1 0 0
25 $788,000 2210 4 3 2 Yes East 1 1 0
26 $746,500 2290 4 3 3 No North 0 0 0
27 $647,000 2000 4 2 3 No West 0 0 1
28 $496,500 1700 3 2 2 No East 0 1 0
29 $345,500 1600 2 2 3 No North 0 0 0
30 $908,000 2040 4 3 1 Yes West 1 0 1
31 $893,000 2250 4 3 3 Yes West 1 0 1
32 $566,500 1930 2 2 2 Yes North 1 0 0
33 $681,000 2250 3 3 3 Yes East 1 1 0
34 $701,000 2280 5 3 4 Yes East 1 1 0
35 $589,000 2000 2 2 3 No North 0 0 0
36 $585,500 2080 3 3 3 No North 0 0 0
37 $587,500 1880 2 2 2 No North 0 0 0
38 $732,000 2420 4 3 4 No West 0 0 1
39 $644,500 1720 3 2 1 No West 0 0 1
40 $541,000 1740 3 2 2 No North 0 0 0
41 $533,000 1560 2 2 1 No East 0 1 0
42 $644,000 1840 4 3 2 Yes West 1 0 1
43 $528,000 1990 2 2 3 No East 0 1 0
44 $776,000 1920 3 2 1 Yes East 1 1 0
45 $823,500 1940 3 3 2 Yes West 1 0 1
46 $516,000 1810 3 2 3 No East 0 1 0
47 $654,000 1990 2 3 2 Yes East 1 1 0
48 $451,500 2050 3 2 6 No North 0 0 0
49 $579,500 1980 2 2 2 No East 0 1 0
50 $539,500 1700 3 2 3 Yes North 1 0 0
51 $761,500 2100 3 2 3 Yes East 1 1 0
52 $455,500 1860 2 2 3 No North 0 0 0
53 $587,000 2150 2 3 4 No North 0 0 0
54 $654,000 2100 3 2 3 No North 0 0 0
55 $406,500 1650 3 2 3 No North 0 0 0
56 $630,500 1720 2 2 2 Yes East 1 1 0
57 $706,500 2190 3 2 3 Yes East 1 1 0
58 $739,500 2240 4 3 3 No West 0 0 1
59 $672,500 1840 3 3 1 No West 0 0 1
60 $766,000 2090 4 2 1 No West 0 0 1
61 $867,500 2200 3 3 1 No West 0 0 1
62 $504,500 1610 2 2 2 No North 0 0 0
63 $757,500 2220 4 3 2 No West 0 0 1
64 $602,500 1910 2 3 2 No East 0 1 0
65 $650,500 1860 3 2 2 No West 0 0 1
66 $561,500 1450 2 2 1 Yes North 1 0 0
67 $631,000 2210 3 3 4 No North 0 0 0
68 $759,500 2040 4 3 3 No East 0 1 0
69 $468,000 2140 3 2 4 Yes North 1 0 0
70 $798,000 2080 4 3 3 No West 0 0 1
71 $787,500 1950 3 3 3 Yes West 1 0 1
72 $781,000 2160 4 2 1 No West 0 0 1
73 $536,500 1650 3 2 3 No North 0 0 0
74 $628,500 2040 3 2 2 No East 0 1 0
75 $698,000 2140 3 3 3 No West 0 0 1
76 $534,500 1900 2 2 2 No North 0 0 0
77 $607,000 1930 3 2 2 No West 0 0 1
78 $883,500 2280 4 3 3 Yes West 1 0 1
79 $606,500 2130 3 2 3 No North 0 0 0
80 $669,000 1780 4 2 1 No West 0 0 1
81 $719,000 2190 3 3 4 Yes East 1 1 0
82 $918,500 2140 4 3 2 Yes West 1 0 1
83 $797,000 2050 2 2 1 Yes West 1 0 1
84 $738,500 2410 3 3 2 No East 0 1 0
85 $452,500 1520 2 2 3 No North 0 0 0
86 $900,500 2250 4 3 2 Yes West 1 0 1
87 $513,500 1900 4 2 4 No North 0 0 0
88 $859,500 1880 3 3 1 Yes West 1 0 1
89 $638,500 1930 3 3 2 No North 0 0 0
90 $489,000 2010 2 2 4 No North 0 0 0
91 $713,500 1920 4 2 2 No West 0 0 1
92 $582,500 2150 3 2 2 No East 0 1 0
93 $674,000 2110 3 2 2 No West 0 0 1
94 $785,500 2080 3 3 2 No East 0 1 0
95 $798,000 2150 4 3 3 Yes West 1 0 1
96 $767,500 1970 2 2 1 Yes West 1 0 1
97 $666,500 2440 3 3 3 No East 0 1 0
98 $636,000 2000 2 2 1 Yes East 1 1 0
99 $705,500 2060 3 2 1 No West 0 0 1
100 $839,000 2080 3 3 2 Yes West 1 0 1
101 $516,000 2010 3 2 5 No North 0 0 0
102 $615,500 2260 3 3 5 No East 0 1 0
103 $684,000 2410 3 3 4 No East 0 1 0
104 $1,012,000 2440 4 3 3 Yes West 1 0 1
105 $411,500 1910 3 2 4 No East 0 1 0
106 $691,500 2530 4 3 4 No West 0 0 1
107 $542,500 2130 3 2 4 No North 0 0 0
108 $673,000 1890 3 2 1 Yes East 1 1 0
109 $591,000 1990 3 3 3 Yes East 1 1 0
110 $543,500 2110 3 2 3 No East 0 1 0
111 $558,000 1710 2 2 1 No North 0 0 0
112 $574,500 1740 2 2 2 No North 0 0 0
113 $624,000 1940 2 2 2 Yes West 1 0 1
114 $583,500 2000 3 2 3 Yes North 1 0 0
115 $622,500 2010 4 3 2 No East 0 1 0
116 $512,500 1900 3 3 3 No North 0 0 0
117 $979,500 2290 5 4 1 Yes West 1 0 1
118 $589,000 1920 3 2 2 No North 0 0 0
119 $755,000 1950 3 2 3 Yes North 1 0 0
120 $548,500 1920 2 2 4 No North 0 0 0
121 $552,000 1930 2 3 3 No North 0 0 0
122 $528,000 1930 3 3 3 No East 0 1 0
123 $730,000 2060 2 2 1 Yes East 1 1 0
124 $599,500 1900 3 3 3 Yes East 1 1 0
125 $743,500 2160 4 3 3 Yes East 1 1 0
126 $567,500 2070 2 2 2 No North 0 0 0
127 $713,500 2020 3 3 1 No West 0 0 1
128 $623,000 2250 3 2 4 No North 0 0 0

5. Suppose it is conjectured that the brick premium varies by neighborhood. To account for this conjecture, we augment Model 1 with interaction terms as follows:

Price = a + b1SqFt + b2Bedrooms + b3Bathrooms + b4Offers + b5Brick + b6East + b7West + b8Brick*East + b9Brick*West

Call this model as Model 2. Estimate this model with StatTools. Include an screenshot of the model output.

6. Provide an economic interpretation of b8 in Model 2.

7. Based in Model 2, what is the brick premium in the:

a. North? $__________

b. East? $__________

c. West? $__________

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus For Scientists And Engineers Early Transcendentals

Authors: William L Briggs, Bernard Gillett, Bill L Briggs, Lyle Cochran

1st Edition

0321849213, 9780321849212

More Books

Students also viewed these Mathematics questions

Question

=+a) Is this an observational or experimental study?

Answered: 1 week ago