Economic

jjdzt
HousePriceData.xlsx
Home>Business & Finance homework help>Economics homework help>Economic

Sheet2

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.0203406764
R Square 0.0004137431
Adjusted R Square -0.0551188267
Standard Error 0.152264803
Observations 20
ANOVA
df SS MS F Significance F
Regression 1 0.0001727357 0.0001727357 0.0074504587 0.9321681103
Residual 18 0.4173222643 0.0231845702
Total 19 0.417495
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.0918352645 0.3223085201 0.2849296831 0.7789503996 -0.5853098092 0.7689803382 -0.5853098092 0.7689803382
Vote Share for Clinton 0.0465971627 0.5398436144 0.0863160394 0.9321681103 -1.087572185 1.1807665104 -1.087572185 1.1807665104
RESIDUAL OUTPUT
Observation Predicted House Change 2004-2015 Residuals
1 0.1205391167 -0.0705391167
2 0.1228689749 0.0471310251
3 0.1215176571 -0.2015176571
4 0.1145280827 0.1754719173
5 0.1160657891 0.2239342109
6 0.1236145295 0.0063854705
7 0.1208652969 -0.0108652969
8 0.1205391167 -0.0205391167
9 0.1188616189 -0.1088616189
10 0.1207255054 -0.0407255054
11 0.1169977324 0.0430022676
12 0.1275752883 0.1824247117
13 0.1188616189 -0.1488616189
14 0.1188616189 -0.2888616189
15 0.1207255054 0.2492744946
16 0.1179296756 -0.1079296756
17 0.117463704 -0.117463704
18 0.1165317607 -0.0565317607
19 0.1169977324 0.2030022676
20 0.1179296756 0.0420703244

Vote Share for Clinton Line Fit Plot

House Change 2004-2015 0.61599999999999999 0.66600000000000004 0.63700000000000001 0.48699999999999999 0.52 0.68200000000000005 0.623 0.61599999999999999 0.57999999999999996 0.62 0.54 0.76700000000000002 0.57999999999999996 0.57999999999999996 0.62 0.56000000000000005 0.55000000000000004 0.53 0.54 0.56000000000000005 0.05 0.17 -0.08 0.28999999999999998 0.34 0.13 0.11 0.1 0.01 0.08 0.16 0.31 -0.03 -0.17 0.37 0.01 0 0.06 0.32 0.16 Predicted House Change 2004-2015 0.61599999999999999 0.66600000000000004 0.63700000000000001 0.48699999999999999 0.52 0.68200000000000005 0.623 0.61599999999999999 0.57999999999999996 0.62 0.54 0.76700000000000002 0.57999999999999996 0.57999999999999996 0.62 0.56000000000000005 0.55000000000000004 0.53 0.54 0.56000000000000005 0.12053911672796662 0.12286897486242089 0.12151765714443741 0.11452808274107462 0.11606578910981444 0.12361452946544625 0.12086529686679022 0.12053911672796662 0.11886161887115955 0.12072550537872297 0.11699773236359615 0.12757528829401849 0.11886161887115955 0.11886161887115955 0.12072550537872297 0.11792967561737785 0.117463703990487 0.11653176073670529 0.11699773236359615 0.11792967561737785

Vote Share for Clinton

House Change 2004-2015

Sheet3

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.3108102905
R Square 0.0966030367
Adjusted R Square 0.0464143165
Standard Error 0.1447533756
Observations 20
ANOVA
df SS MS F Significance F
Regression 1 0.0403312848 0.0403312848 1.9247957769 0.1822678797
Residual 18 0.3771637152 0.0209535397
Total 19 0.417495
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.0163480737 0.0810907045 0.2016023145 0.8424884371 -0.1540171747 0.1867133221 -0.1540171747 0.1867133221
House Price Currently 0.000306407 0.0002208546 1.3873700937 0.1822678797 -0.0001575912 0.0007704053 -0.0001575912 0.0007704053
RESIDUAL OUTPUT
Observation Predicted House Change 2004-2015 Residuals
1 0.1392172923 -0.0892172923
2 0.1968218137 -0.0268218137
3 0.0865152833 -0.1665152833
4 0.082531992 0.207468008
5 0.082838399 0.257161601
6 0.1505543524 -0.0205543524
7 0.1076573683 0.0023426317
8 0.093256238 0.006743762
9 0.0760974444 -0.0660974444
10 0.1447326188 -0.0647326188
11 0.0889665396 0.0710334604
12 0.2403316118 0.0696683882
13 0.1104150316 -0.1404150316
14 0.0647603843 -0.2347603843
15 0.1352340009 0.2347659991
16 0.0944818661 -0.0844818661
17 0.1854847537 -0.1854847537
18 0.0757910373 -0.0157910373
19 0.1238969409 0.1961030591
20 0.1104150316 0.0495849684

House Price Currently Line Fit Plot

House Change 2004-2015 401 589 229 216 217 438 298 251 195 419 237 731 307 158 388 255 552 194 351 307 0.05 0.17 -0.08 0.28999999999999998 0.34 0.13 0.11 0.1 0.01 0.08 0.16 0.31 -0.03 -0.17 0.37 0.01 0 0.06 0.32 0.16 Predicted House Change 2004-2015 401 589 229 216 217 438 298 251 195 419 237 731 307 158 388 255 552 194 351 307 0.13921729230990559 0.19682181374366231 8.6515283338596261E-2 8.2531991962857765E-2 8.2838398991760723E-2 0.15055435237931514 0.10765736833290059 9.3256237974461406E-2 7.6097444355895577E-2 0.14473261883015892 8.8966539569819952E-2 0.24033161184788282 0.11041503159302724 6.4760384286486006E-2 0.1352340009341671 9.4481866090073252E-2 0.18548475367425277 7.5791037326992605E-2 0.12389694086475753 0.11041503159302724

House Price Currently

House Change 2004-2015

Sheet1

House Change 2004-2015 House Price Currently Vote Share for Clinton
5% 401 New York 20,320,876 New York–Newark–Jersey City, NY–NJ–PA MSA Northeast 61.60%
17% 589 Los Angeles 13,353,907 Los Angeles–Long Beach–Anaheim, CA MSA West 66.60%
-8% 229 Chicago 9,533,040 Chicago–Joliet–Naperville, IL–IN–WI MSA Midwest 63.70%
29% 216 Dallas–Fort Worth 7,399,662 Dallas–Fort Worth–Arlington, TX MSA South 48.70%
34% 217 Houston 6,892,427 Houston–The Woodlands-Sugar Land MSA South 52.00%
13% 438 Washington, D.C. 6,216,589 Washington, DC–VA–MD–WV MSA South 68.20%
11% 298 Miami 6,158,824 Miami–Fort Lauderdale–West Palm Beach, FL MSA South 62.30%
10% 251 Philadelphia 6,096,120 Philadelphia–Camden–Wilmington, PA–NJ–DE–MD MSA Northeast 61.60%
1% 195 Atlanta 5,884,736 Atlanta–Sandy Springs–Roswell, GA MSA South 58.00%
8% 419 Boston 4,836,531 Boston–Cambridge–Quincy, MA–NH MSA Northeast 62.00%
16% 237 Phoenix 4,737,270 Phoenix–Mesa–Chandler, AZ MSA West 54.00%
31% 731 San Francisco 4,727,357 San Francisco–Oakland–Fremont, CA MSA West 76.70%
-3% 307 Riverside–San Bernardino 4,580,670 Riverside–San Bernardino–Ontario, CA MSA West 58.00%
-17% 158 Detroit 4,313,002 Detroit-Warren-Dearborn, MI MSA Midwest 58.00%
37% 388 Seattle 3,867,046 Seattle–Tacoma–Bellevue, WA MSA West 62.00%
1% 255 Minneapolis–St. Paul 3,600,618 Minneapolis–St. Paul–Bloomington, MN–WI MSA Midwest 56.00%
0% 552 San Diego 3,337,685 San Diego–Carlsbad–San Marcos, CA MSA West 55.00%
6% 194 Tampa–St. Petersburg 3,091,399 Tampa–St. Petersburg–Clearwater, FL MSA South 53.00%
32% 351 Denver 2,888,227 Denver–Aurora–Lakewood, CO MSA West 54.00%
16% 307 Baltimore 2,808,175 Baltimore-Columbia-Towson, MD MSA South 56.00%