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
Once upon a time, we developed a better method for detecting housing bubbles. Today, we're going back to the data mines to do some refinement and to see where things stand today!
Our first chart shows the relationship between median new house prices in the United States and median household income for the years from 1967 through 2010.
Here, we've revised our earlier look to better define the major trends evident in the data. Here, we see one major trend running from 1970 through 1986, then a second trend running from 1987 through 1999. After 1999, we see the housing bubble beginning its inflation phase as the relationship between median new house prices and median household income became decoupled, running through 2007. Since then, the U.S. housing bubble has been in its deflation phase, which appears to still be ongoing, as the relationship between the median prices of new houses and median household income remains decoupled.
One important thing to note is the shift in the trend that occurred after 1986. We believe this shift was triggered by the Tax Reform Act of 1986, which eliminated a number of debt-related tax deductions, but which left the long-standing mortgage interest deduction in place, even increasing the amount of the deduction.
The changes brought about by the Tax Reform Act of 1986 had two main effects. First, it incentivized home ownership by enhancing the tax benefits associated with owning property and having a mortgage. Second, in eliminating the favorable treatment of other debt interest, it made the home mortgage the primary channel by which people would choose to accumulate debt thanks to the interest on that debt being tax advantaged.
These changes however are not the cause of the U.S. housing bubble, as there is no correlation between the shift in trend and the beginning of the bubble in 2000. More interestingly though, we see that both trends would project nearly the same median new home price given the current level of the U.S. median household income.
Looking at the more recent trend that was defined in the period from 1987 through 1999, we can see that the relative affordability of a median new home in 2010 is still well elevated above where it would have been during that period. The following chart shows the percentage deviation between the 1987-1999 trend and actual median new home prices from 1987 through 2010, which gives a sense of how overpriced the median new home has been since 1999 thanks to the U.S. housing bubble:
Here, we see that the relative affordability of the median new home with respect to where it typically was from 1987 through 1999 peaked in 2005, with a percentage deviation of 25.7%. Since then, the median price of a new home has fallen, bottoming in 2009 at a level 11.9% over where the linear trend that ran from 1987 through 1999 would place it, before bouncing back up to be 14.4% higher than the level of the projected trend in 2010.
What's interesting to us is that it appears that we stumbled directly into something that looks very much like the Case-Shiller house price index!
Here, looking at both the 10-city and 20-city composite indices, we find that our representation above closely follows the pattern traced out by the Case-Shiller 20-city composite data - at least with respect to the linear trend we created in the chart for the period from 1987 through 1999.
But unlike the Case-Shiller data, because our method correlates house prices with household income data, it will better communicate the relative affordability of homes in the U.S. over time!
Since the Case-Shiller data has been updated more recently than the Census data, it appears that house prices in the U.S. have resumed falling in 2011. And even though those falling prices are making homes more affordable today, they would have to fall by roughly another 12-14% before they would be in the same ballpark for affordability that they were in the years from 1987 through 1999.
Or as the projected trend works out to be from our first chart, the same level of affordability that they were for Americans in the years from 1970 through 1986 as well.
U.S. Census. Median and Average Sales Prices of New Homes Sold in United States. http://www.census.gov/const/uspriceann.pdf. Accessed 13 December 2011.
U.S. Census. Current Population Survey, Annual Social and Economic Supplements. Table H-5. Race and Hispanic Origin of Householder--Households by Median and Mean Income: 1967 to 2010. [Excel spreadsheet]. Accessed 13 December 2011.
Standard and Poor. Case Shiller Seasonally Adjusted Home Price Index Levels, September 2011. [Excel spreadsheet]. Accessed 13 December 2011.
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:
This year, we'll be experimenting with a number of apps to bring more of a current events focus to Political Calculations - we're test driving the app(s) below!
The S&P 500 at Your Fingertips
The Distribution of Income for 2010: Individuals
Should You Trade in Your Gas Guzzler?
What Are the Chances Your Marriage Will Last?
Tipping Around the World
What's Your Body Fat Percentage?
The Odds of Dying, Again!
Gas Prices, the Unemployment Rate, and Desperation
Hauser's Law
The Real Story Behind "Rising" U.S. Income Inequality
First Time Visitor to Political Calculations?
On the Moneyed Midways
A Lot, But Not All, of Our Tools
Political Calculations' U.S. GDP Temperature Gauge provides a means to quickly evaluate the growth rate of the U.S. economy against the backdrop of how the economy has performed since 1980, with the "temperature" color spectrum ranging from a recessionary "cold" (purple) through an expansionary "hot" (red).
The GDP Temperature Gauge presents both the annualized GDP growth rate as reported by the U.S. Bureau of Economic Analysis reports for a one-quarter period and also as averaged over a two quarter period, which smooths out the volatility seen in the one-quarter data and provides a better indication of the relative strength of the U.S. economy over time.
This site is primarily powered by:
Visitors since December 6, 2004:
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.
ZunZun - Exceptional regression analysis tool.
Wolfram Integrator - Solve integrals. Do calculus!
Create a Graph - Easy-to-use basic graph-making tool.
Many Eyes - Data visualization extraordinaire!
Wolfram Alpha - Computational knowledge engine.
Khan Academy - Math & science video mini-lectures!
Picasion - Animate images.
Bloodhoundblog
Budgets Are Sexy
Cafe Hayek
Carpe Diem
Core77
Coyote Blog
Craig Harper
Darwin's Finance
Digerati Life, The
Division of Labour
Dough Roller, The
Eclectecon
Econlog
Economics Roundtable
EconomicsUK
Environmental Economics
Escape from Cubicle Nation
Execupundit
FiscalGeek
Get Rich Slowly
Gongol
Good Financial Cents
HR Bartender
Hot Air
i4cp Productivity
Innocent Bystanders
Innovation and Growth
Instapundit
Intangible Economy
I've Paid Twice for This Already
Joanne Jacobs
Kaus Files
Len Penzo dot Com
Making Ripples
Market Power
Mechonomics
Mighty Bargain Hunter
Monevator
My Dollar Plan
New Economist
Newmark's Door
Nina Simosko
Physorg
Private Sector Development
Real Clear Politics
Richard Fernandez
Roger L. Simon
Rowan Manahan
Sound Politics
SOX First
Sports Economist, The
squawkfox
Three Star Leadership
Tim Worstall
Townhall
Trusted Advisor
Uncommon Misperceptions
voluntaryXchange
WILLisms
Winterspeak
Big Picture, The
Crackerjack Finance
CXO Advisory Group
Disciplined Approach to Investing
Dividend Guy, The
Doug Short
Evidence Investing
Fat Pitch Financials
FX Investment Strategies
Oilprice
American Red Cross
Children's Heart Foundation
Salvation Army
SMA Foundation
Kindle Paperwhite 3G - Best e-reader!
Angel in the Whirlwind
Bailout Nation
Cartoon Guide to Statistics
A Comprehensive Guide to the Peloponnesian War
The Complete Personal Memoirs of Ulysses S. Grant
The Count of Monte Cristo
Ender's Game
Gardner's Art Through the Ages
Empire of Wealth
How to Make Presentations to Councils and Boards
Juran's Quality Handbook
Marks' Standard Handbook
The Second World War
Stocks for the Long Run
Why Smart Executives Fail
The Tudors: The Complete Series
Kindle Fire HD 8.9" 4G LTE Wireless 32 GB
Snap Circuits Jr. SC-100
Nerf Vortex Praxis
Sony BRAVIA 40" LED HDTV
2540 Series Docking Station
New Balance MX623
Dunham Men's Waterproof Oxford
TN360 Black Toner Cartridge
The Dangerous Book for Boys
Air Swimmer Remote Control Inflatable Flying Shark
Fisher-Price Little People Lil Pirate Ship