House Hunting in Omaha

Nan Dong, Becky Witt, Jon Weber, Messan Amevor, Nick Navarro

date: 12/17/2015

Home-Buying Koala-fications

alt text

Factors

  • Price
  • Crime Rates
  • School District
  • Age of House
  • Population
  • Size of House
  • Style of House

Cleaning the Data

  • House data

    • started with Zillow database
    • used Nick's secretive database

  • Crime data

    • Omaha Police Department
    • Lots of cleaning…

Listing Price vs Sold Price (2005-2010)

  • Sold Price =3075 + 0.96*Listing Price
  • r2 = 98%

plot of chunk unnamed-chunk-2

Listing Price vs Sold Price (2010-2015)

  • Sold =7651 + 0.94*Listing Price
  • r2 = 98%

plot of chunk unnamed-chunk-3

Crime Rates

  • 6 months of Omaha crime data
  • Downtown Omaha and North Omaha seem sketchy

plot of chunk unnamed-chunk-4

Facet Crime by Month

  • Downtown Omaha and North Omaha still dense in crime plot of chunk unnamed-chunk-5

Types of Crimes

  • So much theft!

plot of chunk unnamed-chunk-6

Population

  • Census Tract Data
  • Elkhorn most populated by 2010

plot of chunk unnamed-chunk-7

Population

  • Census Tract Data
  • Elkhorn most populated by 2010

plot of chunk unnamed-chunk-8 plot of chunk unnamed-chunk-8

Age of House and School District (2005-2010)

plot of chunk unnamed-chunk-9

plot of chunk unnamed-chunk-10

Age of House and School District (2010-2015)

plot of chunk unnamed-chunk-11

plot of chunk unnamed-chunk-12

Size,Style and Price (2005-2010 vs 2010-2015)

plot of chunk unnamed-chunk-13 plot of chunk unnamed-chunk-13

Conclusion

  • Strong correlation between listing price and sold price
  • Most crime in Downtown Omaha and North Omaha
    • mainly theft
  • Elkhorn growing fast
    • population and houses built
  • Split entry and ranch styles most expensive/sq foot

Questions?

alt text