Sunday, September 2, 2007

The Sarcasm Report v.4



Source data can be found here.

4 comments:

Lab Rat said...

What category of data from the source did you use to create the chart? With my limited finance knowledge I can't identify what source and which transformations would be useful.

Does the data go back further than 2000? Some perspective could be created by a view of inflation-adjusted historical trends.

Stagflationary Mark said...

Hey lab rat,

Pick the "Average loan volume/All banks" option. The data goes back to 1985 and is in the "Loans secured by real estate (quarterly average); All commercial banks" column. I think you might need excel to see it.

I'm thinking of doing another chart in my "vs." series showing real estate loan growth vs. total wages. I can virtually guarantee you that one would look ugly, for what it is worth. *sigh*

The small problem with inflation adjustments is that the population growth also drives the loans. In other words, even with no inflation we'd expect to see some growth just as the population grows.

Lab Rat said...

Well, I certainly couldn't let you have all the fun.

chart - source

Inflation and population-adjusted rendition of your chart, by year (I used Q3 data). I'm not entirely confident of the population data prior to 1990.

Stagflationary Mark said...

Spot the last consumer recession on your chart and win a prize!

Well, assuming you offer prizes. It is your chart after all. :)

My version using wages is now up, although I didn't have enough wage data to get me back to that last consumer recession. Oh well!