Housing Fluctuation Using Case-Shiller Index

The mission of this project is to observe and analyse the housing fluctuation of an single familly house from 2001 to 2021 of three cities: Boston, New York City and San Francisco using Case-Shiller Housing Index, as well as trying to determine the factors that might influenced the housing prices.

Housing Fluctuation

Metropolitan Population

Real Median Income

Housing Supply (Monthly)


Analysis Graph 1

San Francisco endured the greatest decline in 2008 Housing bubble, as well as the greatest increased after the crash,much higher than the Case-Shiller 20 City Composite which measures the average housing values of 20 major cities in the US, and for all three cities housing price shows an upward sloping trend, which means that the value of an single-family house keep increasing over time.

Analysis Graph 2

By comparing the first graph and the second, it seems like population is not an factor on housing as San Francisco does not have an greater population than New York City and Boston, and it seems like it doesn’t have an huge increase in population than the other two cities, we can conclude by saying population is not an major factor that determine the housing Price.

Analysis Graph 3

Comparing the first graph and the third, we can say that income is one of the factors that influenced the Housing Price as the ups and downs of the Income graph matched up with the Housing graph.

Analysis Graph 4

This graph represent the general “Supply” curve for housing price, comparing the first graph and this graph we can see that the price follows general models of supply and demand curve in economics, where more supply less demand means price decrease, less supply more demand means price increase.