Question
In: Statistics and Probability
The data below id from 128 recent sales in Mid City. For each sale, it shows...
The data below id from 128 recent sales in Mid City. For each sale, it shows the neighborhood (1, 2, or 3) of the house, # of offers made on the house, sq. footage, whether house is primarily made of brick, # of bathrooms, # of bedrooms, & selling price. Â Neghborhoods 1 & 2 are traditional, 3 is newer/more prestigious. Use regression to estimate & interpret the pricing structure of houses in Mid City.
Q4. Based on the regression of SqFt on Price, each 1 SqFt increase raises the Price by ______.
|
-20182.3 |
||
|
0.3 |
||
|
7.4 |
||
|
140.5 |
| Home | Nbhd | Offers | Sq Ft | Brick | Bedrooms | Bathrooms | Price |
| 1 | 2 | 2 | 1790 | No | 2 | 2 | 228600 |
| 2 | 2 | 3 | 2030 | No | 4 | 2 | 228400 |
| 3 | 2 | 1 | 1740 | No | 3 | 2 | 229600 |
| 4 | 2 | 3 | 1980 | No | 3 | 2 | 189400 |
| 5 | 2 | 3 | 2130 | No | 3 | 3 | 239600 |
| 6 | 1 | 2 | 1780 | No | 3 | 2 | 229200 |
| 7 | 3 | 3 | 1830 | Yes | 3 | 3 | 303200 |
| 8 | 3 | 2 | 2160 | No | 4 | 2 | 301400 |
| 9 | 2 | 3 | 2110 | No | 4 | 2 | 238400 |
| 10 | 2 | 3 | 1730 | No | 3 | 3 | 208000 |
| 11 | 2 | 3 | 2030 | Yes | 3 | 2 | 265000 |
| 12 | 2 | 2 | 1870 | Yes | 2 | 2 | 246000 |
| 13 | 1 | 4 | 1910 | No | 3 | 2 | 205200 |
| 14 | 1 | 5 | 2150 | Yes | 3 | 3 | 252600 |
| 15 | 3 | 4 | 2590 | No | 4 | 3 | 353600 |
| 16 | 3 | 1 | 1780 | No | 4 | 2 | 291600 |
| 17 | 2 | 4 | 2190 | Yes | 3 | 3 | 294200 |
| 18 | 1 | 4 | 1990 | No | 3 | 3 | 167200 |
| 19 | 2 | 1 | 1700 | Yes | 2 | 2 | 222800 |
| 20 | 3 | 2 | 1920 | Yes | 3 | 3 | 334400 |
| 21 | 2 | 3 | 1790 | No | 3 | 2 | 232400 |
| 22 | 1 | 4 | 2000 | No | 3 | 2 | 227600 |
| 23 | 1 | 3 | 1690 | No | 3 | 2 | 183400 |
| 24 | 1 | 3 | 1820 | Yes | 3 | 2 | 212200 |
| 25 | 2 | 2 | 2210 | Yes | 4 | 3 | 312800 |
| 26 | 1 | 3 | 2290 | No | 4 | 3 | 298600 |
| 27 | 3 | 3 | 2000 | No | 4 | 2 | 274000 |
| 28 | 2 | 2 | 1700 | No | 3 | 2 | 198600 |
| 29 | 1 | 3 | 1600 | No | 2 | 2 | 138200 |
| 30 | 3 | 1 | 2040 | Yes | 4 | 3 | 376000 |
| 31 | 3 | 3 | 2250 | Yes | 4 | 3 | 364000 |
| 32 | 1 | 2 | 1930 | Yes | 2 | 2 | 224600 |
| 33 | 2 | 3 | 2250 | Yes | 3 | 3 | 270000 |
| 34 | 2 | 4 | 2280 | Yes | 5 | 3 | 279200 |
| 35 | 1 | 3 | 2000 | No | 2 | 2 | 235600 |
| 36 | 1 | 3 | 2080 | No | 3 | 3 | 234200 |
| 37 | 1 | 2 | 1880 | No | 2 | 2 | 235000 |
| 38 | 3 | 4 | 2420 | No | 4 | 3 | 294000 |
| 39 | 3 | 1 | 1720 | No | 3 | 2 | 262600 |
| 40 | 1 | 2 | 1740 | No | 3 | 2 | 216400 |
| 41 | 2 | 1 | 1560 | No | 2 | 2 | 213200 |
| 42 | 3 | 2 | 1840 | No | 4 | 3 | 267200 |
| 43 | 2 | 3 | 1990 | No | 2 | 2 | 211200 |
| 44 | 2 | 1 | 1920 | Yes | 3 | 2 | 308000 |
| 45 | 3 | 2 | 1940 | Yes | 3 | 3 | 333000 |
| 46 | 2 | 3 | 1810 | No | 3 | 2 | 206400 |
| 47 | 1 | 2 | 1990 | No | 2 | 3 | 259600 |
| 48 | 1 | 6 | 2050 | No | 3 | 2 | 180600 |
| 49 | 2 | 2 | 1980 | No | 2 | 2 | 231800 |
| 50 | 1 | 3 | 1700 | Yes | 3 | 2 | 215000 |
| 51 | 2 | 3 | 2100 | Yes | 3 | 2 | 302200 |
| 52 | 1 | 3 | 1860 | No | 2 | 2 | 182200 |
| 53 | 1 | 4 | 2150 | No | 2 | 3 | 234800 |
| 54 | 1 | 3 | 2100 | No | 3 | 2 | 261600 |
| 55 | 1 | 3 | 1650 | No | 3 | 2 | 162600 |
| 56 | 2 | 2 | 1720 | Yes | 2 | 2 | 251400 |
| 57 | 2 | 3 | 2190 | Yes | 3 | 2 | 281800 |
| 58 | 3 | 3 | 2240 | No | 4 | 3 | 304600 |
| 59 | 3 | 1 | 1840 | No | 3 | 3 | 276200 |
| 60 | 3 | 1 | 2090 | No | 4 | 2 | 310800 |
| 61 | 3 | 1 | 2200 | No | 3 | 3 | 361800 |
| 62 | 1 | 2 | 1610 | No | 2 | 2 | 201800 |
| 63 | 3 | 2 | 2220 | No | 4 | 3 | 322600 |
| 64 | 2 | 2 | 1910 | No | 2 | 3 | 241000 |
| 65 | 3 | 2 | 1860 | No | 3 | 2 | 260600 |
| 66 | 1 | 1 | 1450 | Yes | 2 | 2 | 222200 |
| 67 | 1 | 4 | 2210 | No | 3 | 3 | 252400 |
| 68 | 2 | 3 | 2040 | No | 4 | 3 | 303800 |
| 69 | 1 | 4 | 2140 | No | 3 | 2 | 187200 |
| 70 | 3 | 3 | 2080 | No | 4 | 3 | 331200 |
| 71 | 3 | 3 | 1950 | Yes | 3 | 3 | 333400 |
| 72 | 3 | 1 | 2160 | No | 4 | 2 | 315200 |
| 73 | 1 | 3 | 1650 | No | 3 | 2 | 214600 |
| 74 | 2 | 2 | 2040 | No | 3 | 3 | 251400 |
| 75 | 3 | 3 | 2140 | No | 3 | 3 | 288400 |
| 76 | 1 | 2 | 1900 | No | 2 | 2 | 213800 |
| 77 | 3 | 2 | 1930 | No | 3 | 2 | 259600 |
| 78 | 3 | 3 | 2280 | Yes | 4 | 3 | 353000 |
| 79 | 1 | 3 | 2130 | No | 3 | 2 | 242600 |
| 80 | 3 | 1 | 1780 | No | 4 | 2 | 287200 |
| 81 | 2 | 4 | 2190 | Yes | 3 | 3 | 286800 |
| 82 | 3 | 2 | 2140 | Yes | 4 | 3 | 368600 |
| 83 | 3 | 1 | 2050 | Yes | 2 | 2 | 329600 |
| 84 | 2 | 2 | 2410 | No | 3 | 3 | 295400 |
| 85 | 1 | 3 | 1520 | No | 2 | 2 | 181000 |
| 86 | 3 | 2 | 2250 | Yes | 4 | 3 | 376600 |
| 87 | 1 | 4 | 1900 | No | 4 | 2 | 205400 |
| 88 | 3 | 1 | 1880 | Yes | 3 | 3 | 345000 |
| 89 | 1 | 2 | 1930 | No | 3 | 3 | 255400 |
| 90 | 1 | 4 | 2010 | No | 2 | 2 | 195600 |
| 91 | 3 | 2 | 1920 | No | 4 | 2 | 286200 |
| 92 | 2 | 2 | 2150 | No | 3 | 2 | 233000 |
| 93 | 3 | 2 | 2110 | No | 3 | 2 | 285200 |
| 94 | 2 | 2 | 2080 | No | 3 | 3 | 314200 |
| 95 | 3 | 3 | 2150 | Yes | 4 | 3 | 321200 |
| 96 | 3 | 1 | 1970 | Yes | 2 | 2 | 305000 |
| 97 | 2 | 3 | 2440 | No | 3 | 3 | 266600 |
| 98 | 2 | 1 | 2000 | Yes | 2 | 2 | 253600 |
| 99 | 3 | 1 | 2060 | No | 3 | 2 | 291000 |
| 100 | 3 | 2 | 2080 | Yes | 3 | 3 | 342000 |
| 101 | 1 | 5 | 2010 | No | 3 | 2 | 206400 |
| 102 | 2 | 5 | 2260 | No | 3 | 3 | 246200 |
| 103 | 2 | 4 | 2410 | No | 3 | 3 | 273600 |
| 104 | 3 | 3 | 2440 | Yes | 4 | 3 | 422400 |
| 105 | 2 | 4 | 1910 | No | 3 | 2 | 164600 |
| 106 | 3 | 4 | 2530 | No | 4 | 3 | 293800 |
| 107 | 1 | 4 | 2130 | No | 3 | 2 | 217000 |
| 108 | 2 | 1 | 1890 | Yes | 3 | 2 | 268000 |
| 109 | 2 | 3 | 1990 | Yes | 3 | 3 | 234000 |
| 110 | 2 | 3 | 2110 | No | 3 | 2 | 217400 |
| 111 | 1 | 1 | 1710 | No | 2 | 2 | 223200 |
| 112 | 1 | 2 | 1740 | No | 2 | 2 | 229800 |
| 113 | 2 | 2 | 1940 | Yes | 2 | 2 | 247200 |
| 114 | 1 | 3 | 2000 | Yes | 3 | 2 | 231400 |
| 115 | 2 | 2 | 2010 | No | 4 | 3 | 249000 |
| 116 | 1 | 3 | 1900 | No | 3 | 3 | 205000 |
| 117 | 3 | 1 | 2290 | Yes | 5 | 4 | 399000 |
| 118 | 1 | 2 | 1920 | No | 3 | 2 | 235600 |
| 119 | 1 | 3 | 1950 | Yes | 3 | 2 | 300400 |
| 120 | 1 | 4 | 1920 | No | 2 | 2 | 219400 |
| 121 | 1 | 3 | 1930 | No | 2 | 3 | 220800 |
| 122 | 2 | 3 | 1930 | No | 3 | 3 | 211200 |
| 123 | 2 | 1 | 2060 | Yes | 2 | 2 | 289600 |
| 124 | 2 | 3 | 1900 | Yes | 3 | 3 | 239400 |
| 125 | 2 | 3 | 2160 | Yes | 4 | 3 | 295800 |
| 126 | 1 | 2 | 2070 | No | 2 | 2 | 227000 |
| 127 | 3 | 1 | 2020 | No | 3 | 3 | 299800 |
| 128 | 1 | 4 | 2250 | No | 3 | 3 | 249200 |
Solutions
Expert Solution
Solution: We can use the excel regression data analysis tool for running the regression of Price on Sq FT to find the coefficient of the slope.
Data> Data Analysis> Regression>
input Y range = Price Data
input x range = Sq Ft data
The excel output is given below:
| SUMMARY OUTPUT | ||||||
| Regression Statistics | ||||||
| Multiple R | 0.5530 | |||||
| R Square | 0.3058 | |||||
| Adjusted R Square | 0.3003 | |||||
| Standard Error | 44951.0673 | |||||
| Observations | 128 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 1 | 112145452218.5470 | 112145452218.5470 | 55.5011 | 0.0000 | |
| Residual | 126 | 254595404968.9530 | 2020598452.1346 | |||
| Total | 127 | 366740857187.5000 | ||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | -20182.260 | 37932.208 | -0.532 | 0.596 | -95248.983 | 54884.464 |
| Sq Ft | 140.5 | 18.853 | 7.450 | 0.000 | 103.143 | 177.762 |
Q4. Based on the regression of SqFt on Price, each 1 SqFt increase raises the Price by 140.5.
Answer: 140.5
orchestra answered 2 years agoRelated Solutions
The data below id from 128 recent sales in Mid City. For each sale, it shows...
The data below id from 128 recent sales in Mid City. For each
sale, it shows the neighborhood (1, 2, or 3) of the house, # of
offers made on the house, sq. footage, whether house is primarily
made of brick, # of bathrooms, # of bedrooms, & selling price.
Neghborhoods 1 & 2 are traditional, 3 is newer/more
prestigious. Use regression to estimate & interpret the
pricing structure of houses in Mid City.
Q1. Predict Price (dependent variable) as...
The data below id from 128 recent sales in Mid City. For each sale, it shows...
The data below id from 128 recent sales in Mid City. For each
sale, it shows the neighborhood (1, 2, or 3) of the house, # of
offers made on the house, sq. footage, whether house is primarily
made of brick, # of bathrooms, # of bedrooms, & selling price.
 Neghborhoods 1 & 2 are traditional, 3 is newer/more
prestigious. Use regression to estimate & interpret the
pricing structure of houses in Mid City.
Q2. Predict Price using SqFt...
The data below id from 128 recent sales in Mid City. For each sale, it shows...
The data below id from 128 recent sales in Mid City. For each
sale, it shows the neighborhood (1, 2, or 3) of the house, # of
offers made on the house, sq. footage, whether house is primarily
made of brick, # of bathrooms, # of bedrooms, & selling price.
 Neghborhoods 1 & 2 are traditional, 3 is newer/more
prestigious. Use regression to estimate & interpret the
pricing structure of houses in Mid City.
Q3. Based on the regression...
The data below id from 128 recent sales in Mid City. For each sale, it shows...
The data below id from 128 recent sales in Mid City. For each
sale, it shows the neighborhood (1, 2, or 3) of the house, # of
offers made on the house, sq. footage, whether house is primarily
made of brick, # of bathrooms, # of bedrooms, & selling price.
 Neghborhoods 1 & 2 are traditional, 3 is newer/more
prestigious. Use regression to estimate & interpret the
pricing structure of houses in Mid City.
Q5. Run a multiple regression...
Homes for Sale The dataset HomesForSale has data on houses available for sale in three Mid-Atlantic...
Homes for Sale
The dataset HomesForSale has data on houses
available for sale in three Mid-Atlantic states (NY, NJ, and PA).
Table 1 shows the mean and standard deviation from the three
Mid-Atlantic states, in thousands of dollars. Use this table, the
knowledge that within the US the average house sells for about 265
thousand dollars1, and a 5% significance level to answer
the following questions.
State
n
Mean
Std. Dev.
New York
30
565.6
697.6
New Jersey
30
388.5...
Below is a table that shows ‘for’ and ‘against’ opinions on the topic: ‘City life is...
Below is a table that shows ‘for’ and ‘against’ opinions on the
topic: ‘City life is better than village
life. Discuss.’
Write an essay of about 250 words using ONLY the ideas given in the
table. You must write your
opinion in the conclusion
For------------------------------------- Against
Better facilities -------------------- Very noisy and crowded
More friends ---------------------- Too much traffic
More modern --------------------- Too much pollution
Better opportunities for jobs ---Very expensive
The table below shows the scores of 25 Mathematics students in two mid-term tests and the...
The table below shows the scores of 25 Mathematics students in
two mid-term tests and the Final test score.
Test 1
Test 2
Final Test
75
69
76
95
75
93
91
78
90
98
84
98
75
57
71
54
39
51
71
63
75
48
48
58
89
68
88
81
60
82
71
60
71
72
56
71
95
81
92
81
69
76
72
63
74
95
76
96
80
64
74
83
77
92
90...
5 people from group are given an ID ranging from 1-9 independent from each other's ID....
5 people from group are given an ID ranging from 1-9 independent
from each other's ID. What is the probability that at least 2
people share an ID number?
The table below shows data collected on the vessel calls for a port in Ghana, from...
The table below shows data collected on the vessel calls for a
port in Ghana, from 2007-2016 to study the relationship between the
number of Commercial Vessels (C.V.) and Offshore Vessels (O. V.).
Year 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 C. V. (X)
527 486 481 558 623 611 606 543 615 673 O. V. (Y ) 67 129 475 719
1175 1053 758 844 910 928 Assuming a linear regression model E(Y |X
= x)...
The table shows the number of days on the market for the 36 recent home sales...
The table shows the number of days on the market for the 36
recent home sales in the city of Sonando Hills.
22
13
30
165
104
54
123
38
7
116
176
178
47
156
20
12
165
19
113
53
48
8
46
29
24
31
137
29
2
175
28
55
117
38
70
145
(a1) Construct a frequency distribution and
histogram, using nice (round) bin limits. (Round your
"percent" answers to 1 decimal place.)
Days on...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- PUT IN JAVA PROGRAMMING LANGUAGE The Rectangle class: Design a class named Rectangle to represent a...
- Journal article summary on inter-group conflict Peer Reviewed Journal article from past 3 years. Please include...
- "Ethical Considerations" Please respond to the following: Reflect upon the responsibilities placed on auditors by the...
- A Japanese company has a bond outstanding that sells for 93 percent of its ¥100,000 par...
- What is the difference among the principles of modularization, abstraction, encapsulation, and separation of interface and...
- An investment project costs $20,100 and has annual cash flows of $4,400 for six years. ...
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
ADVERTISEMENT