|Source: Thought Offerings|
The graph above is from hbl's post. It covers the years 1980 to 2007.
The graph below is my attempt to duplicate hbl's graph using the Excel file I talked about in the previous post. It covers 1980 to 2009.
|Source: My Reconstruction of the Numbers|
Wow. hbl's is prettier. Oh, well.
My intent is to see if my graph shows the same general trends as hbl's. It seems to be a pretty good duplicate. I take that to mean I followed the steps correctly, gathering and handling the data.
Looking at just the uppermost trend line, total debt, I do see a few little high spots that don't appear on hbl's graph: 1997, 2000, 2007. So I checked those and the adjacent years: compared the numbers I used for the graph to the original numbers from the original download file. Same numbers. I didn't glitch it. Probably the numbers just got updated since hbl did his study.
So now I have some Japan debt numbers I can use!
The result of my efforts is available at Google Docs in two forms:
- Google Docs file for browsing. (Give the graphs a moment to regenerate.)
- Excel file for preview and download.
The graphs are imperfect in the browse file -- no labels on the key (which kind of defeats the purpose!). The Excel file was created in OpenOffice.