Tag Archives: Federal Home Loan Bank System

Housing Price Index Metro & State Trends

.. HPI quarterly update … use the Housing Price Index (HPI) to examine quarterly or annual housing value appreciation by metro or state. How is housing value appreciation changing among metros of interest? The HPI is calculated in part using home sales price information from Fannie Mae- and Freddie Mac-acquired mortgages. The U.S. HPI all transactions, non-seasonally adjusted, value increased by 5.25 percent from 2014Q2 to 2015Q2. During this period the Sebastian-Vero Beach, FL MSA experienced the highest rate of housing value appreciation among all metros.

Use the interactive table to compare and contrast HPI quarterly data for/among all metropolitan statistical areas, states and the U.S. Use the GIS tools and data resources reviewed below to visually examine and map these data. See related Web section for more detail.

Visual Analysis of 2014Q2-2015Q2 HPI Patterns
The following graphic shows housing value appreciation 2014Q2-2015Q2 by metro based on the HPI.

– click graphic for larger view and details; view developed using CV XE GIS.
Use the HPI GIS project with CV XE GIS software; create different views.
– view/analyze different HPI measures; zoom-in; add labels.
– apply queries; add other geography/data.
– create views/graphics for reports and stories.

HPI Metro & State Patterns Interactive Table
Use the interactive table to view/rank/compare the non-seasonally adjusted “all transactions” HPI for the most recent 5 quarters for all Metropolitan Statistical Areas (MSAs), states and the U.S. The graphic shown below illustrates the start-up view of the table. The blue highlighted value shows the U.S. national annual change 2014Q2 to 2015Q2.

– click graphic for larger view

Ranking Metros
The following graphic illustrates how the table can be used to 1) select only metros and 2) rank metros in descending order based on annual change 2014Q2-2015Q2. The Sebastian-Vero Beach, FL MSA experienced the highest rate of housing value appreciation among all metros.

– click graphic for larger view

Data Analytics Lab Web Sessions
The HPI provides one part of a larger picture of demographic-economic conditions and trends. Join me in Data Analytics Lab sessions where we explore the mechanics of making the HPI thematic pattern view shown above. Examine the process of integrating other data. Create variations of this view or entirely different visual analysis GIS projects.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data.