Slashdot Mirror


Excel Error Contributes To Problems With Austerity Study

quarterbuck writes "Many politicians, especially in Europe, have used the idea that economic growth is impeded by debt levels above 90% of GDP to justify austerity measures. The academic justification came from a paper and a book by Kenneth Rogoff and Carmen Reinhart. Now researchers at U Mass at Amherst have refuted the study — they find that not only was the data tainted by bad statistics, it also had an Excel error. Apparently when averaging a few GDP numbers in an excel sheet, they did not drag down the cell ranges down properly, excluding Belgium. The supporting website for the book, 'This time it is different,' has lots of financial information if a reader might want to replicate some of the results." The Excel error is making the rounds as the cause of the problems with the study, but it's actually a minor component. The study also ignores some post-WWII data for countries that had a high debt load and high growth, and there's some fishy weighting going on: "The U.K. has 19 years (1946-1964) above 90 percent debt-to-GDP with an average 2.4 percent growth rate. New Zealand has one year in their sample above 90 percent debt-to-GDP with a growth rate of -7.6. These two numbers, 2.4 and -7.6 percent, are given equal weight in the final calculation, as they average the countries equally. Even though there are 19 times as many data points for the U.K."

7 of 476 comments (clear)

  1. Does High Public Debt Consistently Stifle growth? by BlackPignouf · · Score: 5, Insightful

    Does High Public Debt Consistently Stifle Economic Growth?

    No, finite resources do.

  2. Excel error? by Richard_at_work · · Score: 5, Insightful

    When I read the title, I expected a calculation or rounding issue, or an internal range issue from built in components and not "dumb ass user didn't set the range correctly when averaging". That's not an Excel error, that's a user error - Excel did exactly what it was told to do.

    1. Re:Excel error? by Rhywden · · Score: 5, Insightful

      "On two occasions I have been asked, 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question."

    2. Re:Excel error? by toxicafunk · · Score: 5, Insightful

      The real news to me is that academic, world-famous, policy-influencing researchers use Excel instead of, say, R or SPSS, etc.

  3. Re:More Statist Bullsiht by Fluffeh · · Score: 5, Insightful

    Anyone who prefers debt is a fucking idiot and shouldn't be trusted.

    That statement is plain daft. It's much too broad. Sometimes debt can be good. For example, getting a mortgage for a home might not be bad. Sure, it would be better to buy with cash and avoid paying all the interest, but if you don't have a pile of cash lying around, you are limited to saving while paying rent. It might actually work out better to get the mortgage.

    Also, getting a loan to start a company might be a great way to have enough capital to get to the market quickly and by doing so make a huge profit.

    Not all debt is bad. Debt without any plan to pay it off and without evaluating whether the costs of managing the debt outweigh the benefits is bad. The problem is that most political parties these days seem to have a horizon of the next election when it comes to balancing the books. The problem with this sort of debt is that they spend up big and have no real plan to pay it back.

    --
    Moved to http://soylentnews.org/. You are invited to join us too!
  4. Re:More Statist Bullsiht by Chrisq · · Score: 5, Insightful

    Attempting to justify more theft of the public and increased government spending.

    It's simple to answer this question, do you want to incur debt or spend money that you have? Anyone who prefers debt is a fucking idiot and shouldn't be trusted.

    Wow this brings stupidity to new levels. A report is widely used to justify government cut backs. The report proves to have mistakes in it that would have given a different result - so pointing out the error is "Statist Bullshit"? There would be some justification in arguing that the report does not matter, though for people who previously used it to argue their case this would be hypocritical. But to argue that we should continue to use the incorrect report because correcting it is statist is just dumb.

  5. Re:Resource by SwedishPenguin · · Score: 5, Insightful

    "BRAINPOWER" would be included in the "labor" category, just as physical labor is. What is with this idea that those of us who work with ideas do not labor? Of course we do, it's just in a different way from those who do physical labor. All forms of labor require some form of mental capacity, some more than others, but the amount of mental capacity required does not make it more or less labor.