Category: Uncategorized

  • Searchable Data For Chrysler Dealerships

    OK… now anyone who wants to look at this is more than welcome to it. 

    This is an Excel file into which I\’ve managed to put all the information about the closed and open Chrysler dealerships. Because wordpress is stupid, I can\’t upload an excel document, so I had to rename it so that it is a Word document. Just download it and change the extension to \”.xls\” and you\’re set to go.

    Chrysler Dealers (Closed and Open) 

    There are four sheets to the file. Two sheets are the raw data as best I could translate it. The other two sheets are the data cleaned up a little bit to make it more readable. 

    WARNING: For anyone who hasn\’t worked with this kind of data before… data is ugly. Some stuff is missing, some things are misspelled, names are inconsistent and addresses haven\’t been parsed. This isn\’t meant to be the most perfect data source of all time. It\’s just a format for the data that can be more easily organized, sorted, parsed, and analyzed.

    So… go at it. From Excel, you should be able to export as a CSV (comma delimited), which is nice and fun to work with from a visualization point of view.

  • To Adjust Or Not To Adjust… (Calling Economists)

    Sadly, not all problems can be solved by the careful application of mathematics.

    I\’m currently trying to figure out how to appropriately calculate the yearly increases in the GDP over the past 100 years. The reason is because, according to President Obama\’s budget estimates, after we get out of the recession, we will have four consecutive years of +5% growth. I\’m trying to compare that growth to economic growth we\’ve had in the past.

    What I need to know is that, when we calculate past growth, is it properly calculated using inflation adjusted dollars or with unadjusted dollars? I seems to me that adjusted is the only way to go, but if there is an economist out there somewhere who can help me answer that question, it would be helpful in getting the statistics right. 

    Of course, it makes all the difference in the calculations. If we don\’t adjust for inflation, then the biggest sustained growth we\’ve had in the last 50 years was 1971 – 1981 in which we had 10 years in a row of +8% growth. But  inflation was so bad that for a couple of those years, it actually outpaced that growth and then some, turning 8.8% growth in Carter\’s last year into -4.2%.

    Ultimately, if we take Obama\’s numbers as adjusted for inflation, he is predicting that his policies will bring the largest sustained growth this nation has seen since the Baby Boomers started entering the workforce in the early-to-mid sixties. This would be quite a trick, since it would be happening while the Baby Boomers are leaving the work force. 

    If we don\’t adjust for inflation, he is predicting about the same kind of economic recovery we saw from 2003 – 2006.

    I\’d like to know which one it is.

  • The National Debt Road Trip

    [youtube=http://www.youtube.com/watch?v=P5yxFtTwDcc&hl=en&fs=1&hd=1]

    In this video, I wanted to take a close look at the historical nature of the US debt. Unfortunately, I couldn\’t say all I wanted to say or it would have been three times as long and I would have bored myself to death trying to make it.

    First of all, I would like to state that I am not trying to defend President Bush\’s spending. I personally think Bush was spending far too much. My preference would be to reduce the debt… or at least stay put and let inflation take it\’s toll on the debt. My point in this video is that it is the most absurd hypocrisy for someone to complain about how much Bush spent and then yawn when Obama is spending so much more.

    A close look at the numbers reveals that this isn\’t even a \”We\’re in a recession, we have to spend that money\” issue. Obama\’s high deficit plans continue long after the recession is projected to end.

    Next, I want to give some pointers to the data I used and then I want to clear up some of the muddier issues in the video.

    This video uses the US Treasury\’s data on the national debt for the debt numbers and adjusts each year for inflation using the inflation numbers on this site.

    In order to understand where the debt would be in 2016, I used the the President\’s estimate in his latest budget proposal. These numbers are generally accepted to be optimistic (the Congressional Budget Office has them pegged at much higher), but I didn\’t want to put the president at an unfair advantage.

    Actually (and I would do this over again if I could) I calculated the future debt with regards to inflation (I assumed about 1.0% inflation per year) so that President Obama is going slower than if I just used his own numbers. I tried to bend the numbers to Obama\’s advantage,  not because I agree with him, but so that there is no room for the accusation of number fudging.

    In retrospect, I think it would have been more fair to assume that the President\’s team had already assumed the inflation calculation and that their 2016 debt data was calculated in 2016 money and not 2008 money.

    So that\’s all about the calculations… now I\’d like to make a note about some other decisions I made. I thought it was important to keep in mind which party held Congress. The reason is because it is actually more accurate to say

    \”Under President So-and-so, the debt increased by X amount\”

    due to the fact that the president only proposes the budget and must work with Congress in order to get a budget passed.

    In 1994, we voted in a Congress that was remarkably fiscally conservative… so much so that they fought a protracted battle with President Clinton in 1995  trying desperately to get him to agree to a lower budget. The press ripped the Republican Congress (particularly Newt Gingrich) to shreds over it and they (the Republicans) ended up conceeding the matter.

    On the other side of things, Reagan tried to pass smaller budgets, but the House of Representitives was heavily Democratic and added to his proposed budget until he refused to sign, leading to another government shutdown.

    Long story short, the budget is a combined effort of what the president proposes and what the Congress decides, so I thought it was only fair to mention both sides of the equation once the debt really started increasing drastically. This, of course, is only more damning to Bush and Obama, since both of them have (or had) a situation in which their party is in complete control of the government.

    Please… feel free to leave questions and I will answer them as quickly as I can.