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
Extremely linear. That's the term we would use to describe the basic relationship between what people pay to live in the homes they own and what they earn.
Here's the evidence. We constructed the chart below from data collected as part of the Consumer Expenditure Survey for each year from 1984 through 2011 (full year data for 2012 won't be available until late September 2013), which presents the average annual amount of money spent toward mortgage and interest payments, property taxes, insurance and other expenses associated with home ownership for a number of income ranges.
In this chart, we've excluded the data for the lowest and highest income ranges presented in the data, since these cover unbounded conditions that makes them outliers with respect to all the other reported data.
The data points are then clustered at the average annual income before taxes that apply for the reported income ranges, which are the standard ranges reported in Table 2 of the Consumer Expenditure Survey, which covers expenditures for various income levels up to $70,000, and also Table 2301 (for 2003 and after), which provides additional detail of average annual expenditures for a number of income levels above $70,000.
Taking all the data together, what we find is that there is a very strong and direct straight-line relationship between the expenditures for home owners and their income before taxes.
That relationship continues to exist after we adjust for the effects of inflation over time. Our next chart shows the same data as the first, but in terms of constant 2011 U.S. dollars.
Just for fun, we next performed a linear regression for the data for three years, 1986, 2007 and 2011, which we've presented in our third chart (all data is presented in terms of non-inflation adjusted current year dollars.)
We selected these years because they include a very long-ago pre-housing bubble year (1986), the peak housing bubble year (2007) and a post-bubble pop year (2011).
Here, we find that the lines for the relationship between housing expenditures and incomes for the non-housing bubble years of 1986 and 2011 are close to parallel to each other, but the slope for the peak housing bubble year of 2011 is considerably steeper, as housing expenditures spread considerably for a given level of income compared to non-bubble years.
That observation suggests that one of the characteristics of a housing bubble is that it will affect the slope of the relationship between housing expenditures and incomes, as expenditures first swell with the inflation phase of the bubble before collapsing after it pops and begins to deflate, in tune with the illusion of having more wealth than can be afforded on the incomes of homeowners.
We think that the actual mechanism by which this phenomenon works is pretty humdrum, largely amounting to homeowners tapping the apparently growing equity in their properties through refinanced mortgages and home equity loans during the inflation phase of the housing bubble, the payments for which are then added to the expenditures for housing. As a housing bubble grows, the slope steepens until it pops, after which the slope levels back out as homeowners struggle to get their housing expenditures back in line with their actual level of household income. (Or as the sentimental data jocks at the Bureau of Labor Statistics like to call them, "consumer units").
It's pretty amazing difference that such an apparently small change in the slope of the relationship between housing expenditures and income makes for all the difference between excessive exuberance and depression in the U.S. housing market.
Labels: 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.