Wednesday, July 25, 2007

An equal opportunity housing bust

Draw your own inferences from the table below, but it sounded like it would be an interesting exercise to plot yesterday's California foreclosure data by county from DataQuick alongside the 2005 census data for race.

The color coding is simple - a red to green gradient per column with red numbers the biggest and green numbers the smallest.


There are some pretty cool features in the new Excel - in this case, for Conditional Formatting, just select a group of cells and pick which color scheme you want.

AddThis Social Bookmark Button
at

4 comments:

  1. AnonymousJuly 25, 2007 7:15 PM

    i'm sure a little olsq will pick something up.

    ReplyDelete
  2. MariniteJuly 25, 2007 8:54 PM

    Are you just reporting the ethnic breakdown of each county or do the percentages for each ethnic group represent their proprtional share of the NODs? So for Yuba, is it correct to say that 63% of the 171 NODs were issued to whites? That's what this table suggests but I find it difficult to believe that is what you meant.

    ReplyDelete
  3. TimJuly 25, 2007 9:15 PM

    It's just the ethnic breakdown for each county.

    ReplyDelete
  4. AnonymousJuly 26, 2007 1:48 AM

    Ron Paul Music videos.

    http://www.ronpaulforums.com/showthread.php?t=9123

    ReplyDelete

Note: Only a member of this blog may post a comment.