Austerity economics only works if you make an Excel formula error


55 Responses to “Austerity economics only works if you make an Excel formula error”

  1. GawainLavers says:

    Where “Excel error” means that the data are not lining up with the “correct answer”, so we need to keep fiddling with the formula until they do.

    The “Excel error” is barely relevant to the assessment of a paper that refused to publish data and was steered away from peer review.

    • Boundegar says:

      Did you even read the paper?  You seem to think that omitting the countries that start with A is good methodology, and including them is “fiddling with the formula.”  Really?

      • HarveyBoing says:

        Did you read it?

        There was a mistake in the Excel worksheet, but according to the actual reporting (as opposed to the Boing Boing read) that was a relatively insignificant component in a broader pattern of problems.

        I.e. if the incorrect authoring of the worksheet were the only problem, this would not really have affected the outcome of the research. Had everything else been okay, the worksheet error in and of itself wouldn’t have led to grossly incorrect conclusions.

      • allotrope says:

        He’s suggesting Reinhart & Rogoff manipulated the data to fit their preconceived notions. The second paragraph refers to how R&R hid the underlying data from public scrutiny.

  2. anon0mouse says:

    Because looking at what’s happening on the street won’t tell you anything.

    • Ito Kagehisa says:

       Hey, that’s anecdotal, so it’s not really real.  You have to have somebody with proper credentials say something before it’s real.


  3. Bearpaw01 says:

    “Reinhart-Rogoff is the main research cited in favor of cutting public services and spending in bad economic times.”

    On the contrary, the R-R research was hardly ever mentioned — it’s a minor footnote in the reams of research that supports austerity.

    Also, we’ve always been at war with Eastasia.

  4. Grey Eyed Man of Destiny says:

    psssst- “Amherst” usually refers to the college, not UMass (at) Amherst.

  5. paul beard says:

    Looking at the countries cited, I grow more convinced that the military expenditures, even in peacetime (weapons development, logistical expenses for 700+ bases) are a big difference between the US and the countries that live under that shield. Those nations show solid growth even with debt, since the borrowed funds go to pay for things people use, like infrastructure, social services, things that support economic growth as bridges and highways and a good health care and education system will do.

    Guns vs butter and we always choose guns.

    • euansmith says:

       If you have enough guns, you will never be short of butter… but how many is “enough”?

      • paul beard says:

        You can make butter from guns?

        There’s a basis for the comparators. They’re orthogonal or independent and mutually exclusive of each other. I realize (or hope) your reply was meant in jest but the idea of getting what you want through violence is a litte too topical right now.

        Ike warned us 50+ years ago about this but we have yet to take it in.

        • chgoliz says:

          “You can make butter from guns?”

          No, but you can make them from soap: John Dillinger is the most famous example.

        • spacedmonkey says:

          No, but you can take butter from people who don’t have as many guns.  Not that you’d bother, because the people with the power to make that decision aren’t  short of butter anyway.

    • bcsizemo says:

      Well someone has to show up with the guns at some point in time…and it always seems to be us (usually in places we aren’t wanted, but that’s a topic for a whole different discussion.)

      Of course realistically most of the “bad” guys in the world hate the Western world, which is basically the US…so in a round about way we are the reason we need all these guns…

  6. dioptase says:

    An interesting point raised elsewhere is that high debt levels and austerity are not opposites.  For example, post WWII Britain had both (high debt and rationing).  And growth.

    So while it may be true that this study doesn’t solidly link debt levels to growth, it has even less to say about links between austerity and growth.  In other words, disproving this study doesn’t automatically prove that austerity is good or bad.  The poof for that lies elsewhere.

    • allotrope says:

      The British economy didn’t normalize until 1953 when it finally entered a longer period of growth. The UK had seen GDP crash during the last two years of war, continuing for another two years after the war because of conversion from a wartime economy, then a modest two year bounce back, then recession, one year of growth, then recession again before finally a return to normalcy with five years of growth. Rationing didn’t end until 1954.

      To be frank, the immediate UK post war period is so complicated it simply can’t be distilled into simple narratives like “austerity works”. For one, it was a period of considerable redistribution of wealth, with the founding of the modern welfare state, including the creation of the NHS in 1948. Does that mean “socialism works”?

    • Antinous / Moderator says:

      For example, post WWII Britain had both (high debt and rationing). And growth.

      And Ealing comedies.

  7. Pag says:

    Has any country improved their lot after starting austerity measures? We’re a few years after many countries tried that approach, you’d think there would be plenty of examples by now, but I can’t think of any. Theory is nice, but if a measure doesn’t work in practice, maybe it should be dropped.

    • Christopher says:

      If the theory doesn’t work when put into practice I’d say it’s time to rethink the theory.

      • GawainLavers says:

        If our tribe’s theory doesn’t work when put into practice, then we must put it into practice harder.

        • allotrope says:

          Barroso, Rehn and the other commissioners know exactly what is
          happening, they just pretend to be surprised when reality diverges from
          official reassurances.

          For Cyprus they officially say it will be no more than a two-year moderate recession before growth resumes in 2015. In an internal paper that got leaked it bluntly states Cyprus will fall into an outright multi-year depression with unemployment comparable to Greece and Spain.

          Obviously they are desperate to save the Euro, which is why they lie through their teeth, but at this stage do they really think it can be saved through austerity? And if they say any other prescription is politically impossible, then how about disbanding the currency union after all? Is it really going to be any more traumatic than this titanic failure?

          • GawainLavers says:

            Ah, but austerity will be reflected by improvements in the stock market, and the stock market is basically the economy, and therefore synonymous with “The Greater Good.”

    • spacedmonkey says:

      That’s how we do it in real sciences.  This is a classic example of how a lot of the research you see in social “sciences” is just thinly disguised ideology.

  8. Kaleberg says:

    First, Powerpoint destroys a space shuttle. Next, Excel destroys the economy. Am I the only one living in terror of MS Word?

  9. tomrigid says:

    You can’t be serious.

    Seriously, Cory; you’re standing against the serious people. By the Law of what things mean when we use words, you are not serious.

    There’s a right answer and they’ve made it very obvious for you. Begin from a position of total agreement (submission, prostration, fear-peeing) and then we can start to have a serious debate.

    • Navin_Johnson says:

      The people who cited this are probably the kind of people who begin their screeds with stuff like “It’s simple economics” “economics 101″ “You don’t know anything about economics”……..

  10. Corwin Joy says:

    I think the summary here is misleading.  The errors in this paper were 0.3% or less and updated versions of the paper, with more data, essentially agree with the Amherst version.  A more informed discussion can be found at the Economist:

    “Using the means misses the point of the HAP paper. – It is an argument about the best measure of central tendency. It is basically the old median v mean debate (though in this case it is an average v average-average).The coding error is worth 30bps, and transcription error is worth 10bps – basically nothing. And of course, the new data was not previously available.
    The medians in RR AER 2010 and RRR JEP 2012 are close to the HAP means. Any fair observor would say that all three papers agree — more debt means less growth.

    • Boundegar says:

      Surely the Economist is a fair observer, having beat the drum for austerity for years.

      The question we’re not supposed to ask is: cui bono?  Who benefits from austerity?  Surely not the poor who become destitute, nor the middle class who become poor.

      I saw a billboard not long ago announcing that “your child’s share” of the national debt is $55,000, or thereabouts.  Horrifying – but false.  Because debt is not parceled out on a per-capita basis, nor does it ever come due.  If it did, my son’s share would be a good deal smaller than Sam Walton’s son’s.

      Since it is the rich who bear the greater burden of taxation, the only ones who benefit from austerity are the rich.  But we aren’t supposed to say it out loud – that would be class warfare.

      • Navin_Johnson says:

        “The Economist” ahem……. classic:

        • allotrope says:

          It’s not The Economist blog claiming it was only skewed by 0.3%. It’s a commenter on the blog named “ricardianambivalence” who wrongly claims that it was only a little bit off. He apparently didn’t wholly read or understand the paper critiquing R&R.

          • Boundegar says:

            But it wouldn’t be on the internet if it wasn’t true!

          • Corwin Joy says:

            I should have clarified, the quote I gave was from a commentator not the Economist.  However, I do think the “ricardianambivalence” critique is valid, it seems like the errors in the original paper are not all that huge.  He gives a detailed breakdown of the calculations so yes, I think he read the paper in detail.  Instead liberals hear what they want to hear “Oh, those conservatives are all wrong and this paper was way off.”

          • Corwin Joy says:

            Basically the “ricardianambivalence” analysis claims that much of the difference comes from the use of mean versus median and doesn’t represent gross errors in the original paper.

          • Navin_Johnson says:

             So austerity works?  In the real world?…………………………..

          • Navin_Johnson says:

             I’ve been itching for an excuse to post that image for a couple days. Don’t bum me out. :)

        • GawainLavers says:

          Fair enough: she spent her entire career fighting against freedom.

      • Pedant says:

        (Funded) Debt does become due. It’s why the treasury holds regular auctions to carry on funding it.
        $55,000 at the 10 year funding rate needs to pay interest of about $950 per year.
        If funding rates were to return to 2006 levels it would be $2770 a year.
        Not bothered to look up what proportion of the US debt is funded, but if all of the 16 trillion is & debt were to return to 2006 levels, funded via 10 year usts, the annual interest would be 800 billion…

        • bcsizemo says:

          I just don’t get why people don’t understand some of these things…or why the “smart” people don’t explain it in easy to see terms.  It’s like your credit card, which you’ve been carrying a balance on and only paying the minimum month payment.  Except for the US we just keep increasing our limit…*sigh*. Yes somewhere to someone we do owe that money (even if it is ourselves.)

          • Brad Bell says:

            That’s exactly the problem. It’s not like a credit card because you control the money supply. Unlike Greece, Cyprus, Spain, Portugal, Ireland, etc. Similarly there is not a simple household finance model for controlling the money supply. 

      • heng says:

         So should we keep increasing borrowing until the entirety of the tax take is spent on servicing that debt? Is then a reasonable time for austerity? The UK is currently spending £43 billion a year (or about 7.5% of the entire tax take) to pay interest on debt. Since 1800 there are 3 big spikes in national debt – all the rest of the time the general trend is downwards. The first was during the Napoleonic wars, the second 2 during the two world wars. Only in the last 15 years has the trend been to rise again.

  11. Richard_Kirk says:

    An Excel spreadsheet loses Belgium, and the resultant warp in data dicks with the world economy? It seems someone in Heaven has hired Douglas Adams as a consultant with a brief to make reality ‘more interesting’.

  12. grimc says:

    Carmen Reinhart is a senior fellow at the Peter G. Peterson Institute for International Economics.

    Peter G. Peterson is a billionaire who has promised to spend $1 billion of his money to kill off Social Security and Medicare by convincing people that programs like these will destroy America. Heard of “”? That’s Peterson’s astroturf operation.

    Obviously, this means this was an innocent coding error on Reinhart’s part. Who doesn’t screw up an Excel sheet once in a while, amirite?

    • Heevee Lister says:

      Think about all the billions of dollars that have been spent burning the social safety net and electing pro-austerity politicians.  What if we’d spent that money on something useful – say, extending Medicare to cover everyone, or building more good public housing, or something like a modern WPA? 

  13. Cowicide says:

    Corporatists love these happy “errors”.

  14. msbpodcast says:

    I once had to do an exhaustive check of a calculation routine for figuring out something about amortizing loans over time.

    The software used was written using Smalltalk and used 11 digits of precision before and 11 digits of precision after the decimal point. It actually did complete iterations over the life of a loan to arrive at precise results.

    There were NO ERRORS possible. If the calculations drifted, the precision was automatically increased. (The routine was responsible for figuring out EXACT payment amounts for multi-billion dollar loans, but converted to Turkish Lira.)

    After a week of trying to see if there were any boundary conditions and running exhaustive checks, I gave up and asked who was reporting the error and how he was getting it.

    It tuned out that the person who reported the error was comparing the results of our calculation routine and the approximations he was getting as a result of running an Excel spreadsheet which used integrals to approximate the results.

    Once I had stopped laughing, I explained to my boss that the Excel integration results were done using Newton’s method of approximating a value and could not be counted for results of any precision. (It might be handy for eliminating repeated calculations but it did so at the prive of introducing unavoidable errors in the results.)

    The work-order for that error ticket was returned to the marketing and sales department with my written request that they never use Excel again.

  15. Brad Bell says:

    Even if you don’t make the Excel error, austerity is still something you do during booms, not busts.  All this does is harm R&R’s trustworthiness. 

    In the UK we have austerity explicitly to reduce the deficit and debt. What is happening is we are increasing the deficit and debt. The reason is pretty simple. Osbourne announces austerity and 120 million testicles/ovaries instantly retract amid vows not to spend any money. It’s time to hoard what there is. Literally everyone tries not to spend any money. Business doesn’t invest. Banks don’t lend (as *they* already have debts over 600% of GDP and their best bet is high stakes gambling with computers). Consumers don’t have jobs. Consumers don’t have money. Consumers don’t consume. Falling demand leads to layoffs. Less income. Less taxes paid. Increasing need for former taxpayers to claim social insurance. That’s austerity – a really simple economic death spiral. And the HUGE POINT: government has less income from taxes, more outgoings in benefits claims, and deficit and debt increases at a cost of enormous job losses and hardship for virtually everyone. We are tearing up the fabric of society to *increase* the deficit and debt.

    If government *invested* money – not spent – invested wisely, it could begin a positive life-sustaining economic feedback cycle instead a negative death spiral. We face an existential threat from climate change and there is an energy revolution waiting to be developed. My kids might need a job in 20 years. Get that going. Educate them. Fucking *feed* them. A million kids already go hungry in the UK, and apparently the pain hasn’t even begun!

    The IMF announced it made a mistake with austerity, which Osbourne et al ignored. The IMF miscalculated the multiplier, which describes the amount of economic value resulting from government investment. In the UK, every £1 invested by government would currently return £1.50 of economic value. So the UK is a great government investment. Especially when the government can borrow at historically low low rates, which inflation will later reduce – and government has a lever over inflation, which is also very currently low. It’s a no-brainer. We know austerity raises debt, so at the very least, investing is a more sane option. And there are likely *other* options. But the one thing we do know is austerity now is stupid. Yet Osbourne won’t change course. Most economists in the world agree what he is doing is foolish. I saw Larry Somers struggle to maintain a straight face when asked about it. He literally, nearly burst out laughing.  Osbourne is an Excel error. No feedback. No response. The button is blinking, but the app has crashed.

Leave a Reply