Friday, October 29, 2010

Quick and Dirty in Excel


A response to Greg's comment on yesterday's post.


This one is not "national debt" but "Debt of domestic nonfinancial sectors", conveniently listed alongside M1 and M2 money in the Economic Report of the President. (2010 issue, or maybe 2009.)

I subtracted M1 from M2 to get "savings" ... I indexed "savings" and "Debt" on their average values (like Friedman explained in Money Mischief)... and plotted the index values.

The two lines are substantially similar. Can't say, however, how much of the similarity is due simply to "growth." Probably a lot.

//

Without indexing, the debt numbers are far higher than savings. National debt is a small part of total debt... I need another graph.

Thanks, Greg.

Art
at

2 comments:

  1. GregOctober 29, 2010 at 6:02 AM

    You might have to subtract out the debt held by China and Japan or just add to dollar savings that held by CHina/Japan.

    ReplyDelete
  2. The ArthurianOctober 29, 2010 at 6:57 AM

    Hey, buddy...
    I might have to find the data, first!!
    :)

    ReplyDelete

The spam filter's been acting up again lately. I'm aware, and checking it often.
Oh, what fun they must have with this at Blogger!