Tag Archives: metro data analytics

Examining Metro Housing Value & Household Income Patterns

.. with release of the American Community Survey 2014 (ACS 2014) 1-year estimates, it is now possible to compare the annual change in a range of demographic-economic measures for individual metropolitan areas — metros with 65,000 or more population. For example, the change in median household income, 2013-to-2014 ranged from -$8,966 (Houma-Thibodaux, LA MSA) to $9,789 (Marshall, TX MISA). The change in median housing value, 2013-to-2014 ranged from -$23,200 (Pinehurst-Southern Pines, NC MISA) to $79,700 (Santa Cruz-Watsonville, CA MSA). While these are estimates, and subject to estimation error, these data offer new insights into recent levels and short-term change characteristics. This section reviews data and tools available to analyze metro patterns and characteristics. ┬áSee more detail in this related Web section.

ACS 2013 and 2014 1-year estimates are included in the interactive table for population, median household income and median housing value. The 2014 median housing value-to-median household income is also included. Where do your metros of interest rank? See the interactive table (also reviewed below).

2014 Median Household Income by Metro
The following graphic illustrates use of the ACS 2014 data to develop a thematic pattern map of median household income by metro (metros having 65,000 or more population). This graphic makes use of one subject matter item among hundreds of ACS subject matter items tabulated. Click graphic for larger view showing legend and mini profile example.

— view developed using CV XE GIS software and related GIS project.
— see details for information about the data used to develop the above view.

Metropolitan Area Housing Value & Household Income: 2013-2014
— the following graphics illustrate use of the full interactive table.

Interactive Table Start-up View
Individual metros are displayed by row. Attributes of metros are arrayed by column. Click column headers to sort/rank. The table is a scroll section showing all metros 65,000 population of more and is initially sorted on 2014 population in descending order. Use tools below the table to perform queries on the table.

– click graphic for larger view.

Using the Interactive Table for Peer Group Analysis
Set the population threshold to view only metros having population 100,000 to 500,000 (or any other range) and then click $MHI (median household income) 2014 column header to sort/rank this group on that column. Click a row; the row blue highlights. Optionally copy this row content to clipboard and paste in Excel or use with other software.

– click graphic for larger view.

ACS & Data Analytics
Data Analytics can help most any organization more effectively reach goals and objectives. Whether a new or established business, serving a county or national market, similar tools and methods apply. The ACS data provide one important part of the data for Data Analytics. Subsequent posts will illustrate how to integrate ACS data with other data to gain important insights.

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.