Introduction of House price data project in
the United States
The
statistical analysis for house price change in the United States shows 6.47%,
32.86% and 28.18% increase in 1 year, 5 years, and 10 years respectively (Globalpropertyguide. com, 2019). The main concern of
the project is to explore the dataset of house price changes by county. The
analysis will be beneficial in evaluating the financial crisis. In the thesis, the
research outcome will explain why some countries are fared better than others
and provide valuable support to the theory, data and research. The initial step
is to collect data on house prices from the website and then find results
through data analysis process (Iley & Lewis, 2007).
Analysis of House price data project in the
United States
The
research results show the overall crisis of the housing market in the United
States that are plunged in the country for recession. The data collected in the
analysis is showing house price change from 2012 to 2018. The median house
price is used to measure and increase in 2018 as compared to increase in price
growth from 2012. The smaller amount in the data shows a slowdown of the home
price growth. The increase values are different from each other. The
affordability index for the selected cities of the United States is also
considered in the analysis (Noguchi & Poterba, 2007). The analysis also
considers the percentage of annual income change in the median-priced home. The
analysis shows that New York is the least affordable city of United States.
While on the other hand, the most affordable city of the United States in
Detroit. Different metro areas of the United States are selected in the analysis
and the affordable prices are considered for the homes in the United States. The
home price change in different cities is considered to represent metropolitan
statistical areas (Kiplinger. com, 2019). The data collected
for the analysis in the present report is mentioned in table 1.
Table 1:
Data collected for analysis of house price change
Metro Area
|
Median home price
|
% change since the peak
|
% change since the bottom
|
Index
|
Austin, Texas
|
290,000
|
2.2
|
81.1
|
80
|
9
|
Baltimore, Md.
|
248,000
|
6
|
-15.8
|
26.7
|
5
|
Chicago, Ill.
|
215,000
|
6.1
|
-18.4
|
62.8
|
4
|
Harrisburg, Pa.
|
163,000
|
4.7
|
3.4
|
16.9
|
3
|
Houston, Texas
|
178,000
|
4.5
|
37.2
|
77.1
|
4
|
Las Vegas, Nev.
|
266,000
|
14.9
|
-20.9
|
137.1
|
8
|
Los Angeles, Calif.
|
634,000
|
7.1
|
6.1
|
91.6
|
10
|
New Orleans, La.
|
184,000
|
5.5
|
11.2
|
48.5
|
4
|
New York, N.Y.-N.J.
|
410,000
|
9.2
|
-4
|
38.1
|
10
|
Pittsburgh, Pa.
|
138,000
|
5.9
|
16.5
|
32.1
|
2
|
Portland, Ore.
|
370,000
|
6.3
|
39.3
|
86.6
|
9
|
San Francisco, Calif.
|
860,000
|
9.3
|
22.4
|
127.4
|
10
|
San Jose, Calif.
|
1,100,000
|
13.8
|
48.8
|
130.1
|
10
|
Tulsa, Okla.
|
146,000
|
2.3
|
10.9
|
24.1
|
3
|
Virginia Beach, Va.
|
217,000
|
4
|
-12.4
|
21.1
|
9
|
Washington, D.C.-No. Va.
|
375,000
|
4.3
|
-13.9
|
37.5
|
9
|
Winston-Salem, N.C.
|
144,000
|
5.7
|
8.1
|
29.1
|
2
|
Worcester, Mass.
|
241,000
|
6.1
|
-9.3
|
54.7
|
7
|
Youngstown, Ohio
|
77,000
|
1.8
|
-22.8
|
24.5
|
1
|
Rochester, N.Y.
|
137,000
|
6.8
|
17.4
|
27.5
|
4
|
Percentage change in the peak values
The
total number of observations in the analysis is 20. The multiple R is 0.028, R
Square is 0.0008, and standard error is 3.47. The regression values and
residual values are 0.17 and 217.8 respectively. The significance values are
0.9. The t-test analysis shows 95% upper and lower values as 8.09 and 4.62. The
p-value is
.
SUMMARY OUTPUT
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics
|
|
|
|
|
|
|
|
Multiple R
|
0.028401
|
|
|
|
|
|
|
|
R Square
|
0.000807
|
|
|
|
|
|
|
|
Adjusted R Square
|
-0.0547
|
|
|
|
|
|
|
|
Standard Error
|
3.478519
|
|
|
|
|
|
|
|
Observations
|
20
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA
|
|
|
|
|
|
|
|
|
|
df
|
SS
|
MS
|
F
|
Significance F
|
|
|
|
Regression
|
1
|
0.17582
|
0.17582
|
0.01453
|
0.905389
|
|
|
|
Residual
|
18
|
217.8017
|
12.10009
|
|
|
|
|
|
Total
|
19
|
217.9775
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients
|
Standard Error
|
t Stat
|
P-value
|
Lower 95%
|
Upper 95%
|
Lower 95.0%
|
Upper 95.0%
|
Intercept
|
6.358232
|
0.825232
|
7.704782
|
4.17E-07
|
4.624484
|
8.09198
|
4.624484
|
8.09198
|
X Variable 1
|
-0.00359
|
0.02982
|
-0.12054
|
0.905389
|
-0.06624
|
0.059055
|
-0.06624
|
0.059055
|
Percentage change since bottom
The
total number of observations for the lower value of house price change in the
analysis is 20. The multiple R is 0.711, R Square is 0.506, and standard error
in lower value of house price change is 2.44. The regression values and
residual values are 110.3 and 107.6 respectively. The significance values are
0.0004. The t-test analysis is used for the 95% upper and lower values and the
values are 4.8 and 0.57. The p-value is
.
SUMMARY OUTPUT
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics
|
|
|
|
|
|
|
|
Multiple R
|
0.711437
|
|
|
|
|
|
|
|
R Square
|
0.506143
|
|
|
|
|
|
|
|
Adjusted R Square
|
0.478706
|
|
|
|
|
|
|
|
Standard Error
|
2.445515
|
|
|
|
|
|
|
|
Observations
|
20
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA
|
|
|
|
|
|
|
|
|
|
df
|
SS
|
MS
|
F
|
Significance F
|
|
|
|
Regression
|
1
|
110.3277
|
110.3277
|
18.44777
|
0.000436
|
|
|
|
Residual
|
18
|
107.6498
|
5.980544
|
|
|
|
|
|
Total
|
19
|
217.9775
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients
|
Standard Error
|
t Stat
|
P-value
|
Lower 95%
|
Upper 95%
|
Lower 95.0%
|
Upper 95.0%
|
Intercept
|
2.689404
|
1.007726
|
2.668784
|
0.015654
|
0.572249
|
4.806559
|
0.572249
|
4.806559
|
X Variable 1
|
0.061962
|
0.014426
|
4.295087
|
0.000436
|
0.031653
|
0.09227
|
0.031653
|
0.09227
|
Conclusion of House price data project in
the United States
In the present
report, regression analysis is carried out to evaluate the change in house
prices in the United States. The change in the price is shown for four years
from 2014 to 2018. The increase in house prices is causing financial crises to
the economy of the world. Across the world, the prices of houses are reduced to
34% during the six-year from 2012 to 2018. The American cities index trans are
considered to measure the post-recession.
References of House price data project in the United States
Globalpropertyguide. com. (2019). Home price trends.
Retrieved from www.globalpropertyguide.com:
https://www.globalpropertyguide.com/home-price-trends
Iley, R. A., &
Lewis, M. (2007). Untangling the US Deficit: Evaluating Causes, Cures and
Global Imbalances. Edward Elgar Publishing,.
Kiplinger. com. (2019). Home
Prices in the 100 Largest Metro Areas. Retrieved from www.kiplinger.com:
https://www.kiplinger.com/tool/real-estate/T010-S003-home-prices-in-100-top-u-s-metro-areas/index.php
Noguchi, Y., &
Poterba, J. M. (2007). Housing Markets in the United States and Japan.
University of Chicago Press.