to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
For us, one of the more annoying aspects of the partial federal government shut down in the first half of October 2013 was that the Obama administration chose to shutter its economic data reporting. While the delays in reporting jobs and inflation data drew a lot of attention, there is one delay that is still ongoing: the Census Bureau's reporting of home sales data.
At present, the Census Bureau has indicated that it will publish the data it has collected for U.S. home sales in the months of September 2013 and October 2013 on 4 December 2013. The data for September 2013 had been originally scheduled to be reported on 24 October 2013, while the data for October 2013 was originally be scheduled to be released on 27 November 2013.
As best as we can tell, there is no legitimate reason for that delay, particularly for the data for September 2013. At worst, this data should have been reported no more than 16 days behind schedule - the duration of the actual partial federal government shut down. By no means should it take the 41 days that the Census Bureau is going to take to do it.
That particular data is particularly significant at present because the Census' data through August 2013 indicated that the prices for new home sales may be topping out. Since the data leading up to that point indicates that the real estate market has been experiencing bubble-like conditions, if prices are indeed peaking, that pretty much leaves just one place they can go if history provides any indication.
That's something that would have considerable consequences for the U.S. housing market. But apparently, the management of the U.S. Census Bureau would appear to have other priorities. And because that's the case, we've been shopping for an alternative, private-sector data source to replace them.
So we turned to Zillow's Real Estate Market Reports, which reports median sale price data for the nation's major metropolitan real estate markets. While they don't yet break out new home sale prices from their data (that's a hint Zillow developers!), which would make them a more reliable replacement for the federal government's bureaucracy, if there is a correlation between their total market sale price data and the new home sale price data, we can still use their data.
The chart below shows the twelve-month trailing average for both the U.S. Census Bureau's median new home sale price data and Zillow's whole-market median sale price data:
We've calculated the twelve-month trailing average for both data sources to eliminate the effect of seasonality on home sale prices.
Looking over the chart, we find that there would appear to have been a very close correlation between the two in the period preceding October 2009, which has diverged considerably in the period since. Our next chart shows the relationship between Zillow's median home sale prices and the Census Bureau's median new home sale prices:
What's amazing here is that the correlation between Zillow's whole market median sale prices and the Census Bureau's median new home sale price data was so strong in the period up through September 2009, which coincides with the period preceding, during and following the first U.S. housing bubble.
It's not until after September 2009 that we see median sale prices for new homes and the whole market begin to diverge and follow a new trajectory.
What this chart captures in the period after September 2009 is the ongoing depressed condition of the existing house market in the U.S., where existing home prices continued to fall as many homeowners remained underwater on their mortgages, generating large numbers of foreclosures that continued to drag the sale prices for existing homes down long after the end of the December 2007-June 2009 recession. By contrast, we see that new home sale prices began to rise with the post-recession economic recovery in the U.S.
It was not until early in 2012 with the large scale entry of major commercial real estate investment firms seeking to expand their businesses into the residential market that the market for these homes turned around.
Now for some analysis. This latter chart shows how elevated that median new home sale prices have become with respect to the median home sale prices for the whole market. If the relationship between the two returns to their historic correlation, either new home sale prices must fall or existing home sale prices must rise.
Alternatively, and more desirably, the two could begin following a new track, largely parallel to their relationship preceding September 2009, but based upon their current relative valuations.
Determining which scenario is taking place would require the median new home sale price data, which is why we're particularly peeved about this issue, since the Census Bureau has arbitrarily chosen to lock it up until later this week.
Frankly, the data is too important to be entrusted to the federal government. They just don't add enough value to justify their role in this area.
U.S. Census Bureau. Median and Average Sales Prices of New Homes Sold in the United States. [Excel Spreadsheet]. Accessed 20 November 2013.
Zillow. Real Estate Market Reports. [Excel Spreadsheet]. Accessed 20 November 2013.
Labels: data visualization, real estate
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.