Data Analysis With RMD

Data Analysis With RMD

I begin by doing an analysis on the various regions’ real estate and rental markets.
I will look at the ranges the various markets go through over a prescribed period of time.
Graphical representations will be created in order to make a more in-depth analysis.
I had to drill down into the data further to make better observations when some of the data appeared to be incorrect.

These are some examples for a few analyses that were conducted on the Zillow ZHVI data with R studio.

Wake County Home Sales

a. What have been the overall trends in Wake County Home Values?

  • Overall the trends have been positive.

b. There were dips in home values in the past 20 years. What years did these occur?

  • Yes there were two dips in the values the first was 1997 through 1998 and the second was from 2009 through 2012.

c. Based on the analysis, where would be the least expensive area to purchase home? Most expensive area?

  • Zebulon was the least expensive area.

  • New Hill was the most expensive in 2018.

d. Are any area home values trending down? Is there one area that stands out compared to others?

  • I do not see any regions that are declining in value within Wake County.

  • If I investigate further I do a small decrease in New Hill in October 2018.

  • New Hill stands out compared to the regions and it appears to be an anomaly based on historical data.

  • New Hill will need further investigation with more recent data.

  • Upon Further investigation New Hill is indeed accurate with the current data provided.

NC Rental Market

a. What has been the overall trend in the rental market around the state? Are there any cities that have not followed this trend?

  • The overall trend has been an increase in the rental costs in the evaluated cities.

  • Fayetteville did not follow the trend, the retal rate dropped in 2011 and again in 2016 before returning to a more normal level in 2017.

b. Where is the most expensive city to rent in? Least expensive?

  • Currently the most expensive city to rent in is Asheville while the least expensive is Fayetteville.

c. You are trying decide between Wilmington and Asheville. Which market has the lowest rent?

  • Wilmington has lower rent than Asheville in 2017.

a. According to the results, which market has the lowest median price (represented as horizontal bar in

box plot)?

  • Charlotte-Concord-Gastonia had the lowest median price.

b. The violin plot will show density meaning the wider the plot is, the more observations occur within

that area. Which market has the most density around the median value of homes?

  • Charlotte-Concord-Gastonia once again has the largest density around the median value in that metro area.

Relocation Home Value Comparison













    

  1. Based on your analysis, which city’s housing is most affordable? Least affordable?
    2. 



    

  • Houston-The Woodlands-Sugar Land appears to be the most affordable, and New York-Neward-Jersey City are the least affordable.
    • 



    

  1. Which cities saw the largest change in prices over the past 5 years? Which city has remained more
    2. 



consistent (i.e., no huge swings up or down in home values)?


    

  • During the past 5 years New York-Neward-Jersey City, and Denver-Aurora-Lakewood saw the largest change in prices.
    • 

  • Houston-The Woodlands-Sugar Land has the most consistent housing market since 1996, and Chicago has had the most consistent housing market during over the past 5 years.
    • 



    

  1. During the market downturn in 2012, which cities were most impacted? Which cities have
    2. 



recovered?


    

  • New York-Newark-Jersey City and Chicago-Naperville-Elgin were the most effected by the 2012 downturn.
    • 

  • All the cities have recovered since the 2012 market downturn.
    •