Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started