The Excel Error That Helped Justify Years of Austerity

1789342576144

So in 2010, two very respected Harvard economists; Carmen Reinhart and Kenneth Rogoff published a paper that ended up shaping economic policy for millions of people across two continents. The paper was called “Growth in a Time of Debt,” and the main finding was simple enough to fit into one headline: once a country’s public debt crosses about 90% of its GDP, growth slows down sharply dropping to an average of -0.1%.

That one number became one of the most quoted statistics in global economic policy debate. In the years after the 2008 financial crisis, as governments across Europe and North America were trying to figure out what to do about rising public debt, this paper kept coming up. Policymakers cited it again and again to justify austerity — all those spending cuts and tax increases meant to bring debt down, even if it meant slower growth in the short term. Politicians on both sides of the Atlantic, including US Congressman Paul Ryan, referenced this paper directly in real policy debates.

There was just one problem. The number was wrong simple put

Now, here’s how it actually got caught

In early 2013, a PhD student named Thomas Herndon, studying at the University of Massachusetts Amherst, was given a pretty routine assignment for his graduate econometrics class replicate the results of a well-known published paper. He picked “Growth in a Time of Debt.”

He expected to get the same numbers Reinhart and Rogoff got, and then build on the argument from there. But he couldn’t reproduce their results at all. Now, instead of just assuming he was the one who made a mistake, Herndon did something smart he emailed the original authors directly. And to their credit, they actually responded by sending him their real working spreadsheet.

What he found inside it, working with his professors Michael Ash and Robert Pollin, was a basic spreadsheet formula error. When Reinhart and Rogoff calculated the average growth rate across high-debt countries, their Excel formula simply didn’t extend far enough down the spreadsheet and because of that, it accidentally left out five countries entirely: Denmark, Canada, Belgium, Austria, and Australia.

I want to be clear about something this wasn’t fraud. Nobody manipulated anything on purpose. It was the kind of small, very human mistake that happens in spreadsheets all the time a formula range that should have covered a few more rows, and didn’t.

But the corrected number told a completely different story

Once Herndon, Ash, and Pollin fixed the calculation, everything flipped. Instead of -0.1% growth for high-debt countries, the real number was +2.2% a difference of more than two full percentage points, and a complete reversal of what the original paper claimed.

The reaction from economists was fast, and in some places, pretty blunt. One widely shared comment, from Mike Konczal at the Roosevelt Institute, said he hoped future historians would remember that one of the intellectual foundations for the global move toward austerity in the early 2010s came down to somebody forgetting to update a row in a spreadsheet formula.

Now, to be fair to the original researchers, the full picture is a bit more nuanced than “one Excel error caused austerity.” Economists still argue about how much this paper actually drove policy, versus just confirming what many governments were already leaning toward anyway. Some later research even found more modest relationships between high debt and growth, even after the correction. And Reinhart and Rogoff themselves have maintained that their broader argument about debt and growth still holds up, even after admitting the error.

But here’s the part nobody disputes a hugely influential number, cited over and over in real policy debates that shaped real government spending decisions, was built on a data error that took three years, and one graduate student who simply refused to accept “I just can’t replicate this,” to finally uncover.

What this actually teaches us

A few things are worth sitting with here.

First of all, this wasn’t some obscure, low-stakes paper. It was written by two of the most respected economists in the world, from one of the most respected universities in the world and it still had an error big enough to completely reverse its main conclusion.

Second, that error wasn’t caught by peer review. It wasn’t caught by editors. It wasn’t even caught by the many policymakers who cited the paper for years. It was caught by a student, doing a class assignment, with no stake in the outcome at all someone who was just trying to reproduce the work honestly, and who refused to assume the mistake had to be his own.

Third and this is the part that matters most for anyone who works with data the consequences of that error didn’t stay inside academia. They moved directly into government budgets, into spending decisions, and by extension, into the everyday economic reality of people who never read the paper, and never will.

This is really the whole argument for taking data validation seriously at every single stage not because researchers are careless, but because even careful, credentialed, well-meaning people still make small errors. And once a number becomes convenient enough to quote, almost nobody goes back to check it again.

So where does that leave us

The Reinhart-Rogoff error is now a well-known cautionary tale in economics, but honestly, the lesson goes far beyond just this one paper. Any research that shapes real decisions a national health policy, a development program, a market strategy, a government budget carries this same risk. The data underneath it deserves just as much scrutiny as the conclusion sitting on top of it. Not scrutiny that only shows up after the policy is already in motion scrutiny from the very beginning.

Academic research is going to keep shaping the systems people rely on every day, whether we like it or not. The real question is just whether the data underneath it gets checked before the decisions are made or years later, by someone doing a class assignment.

If a Harvard-level paper could carry an error this significant, and it took three years and one graduate student to catch it, then no research no matter how credible it looks should be trusted on reputation alone.

At WeCollect, this is exactly the gap we built our platform to close. Every response verified, every location confirmed, every anomaly flagged while the data is still being collected not years later, when the damage is already done.

If you’re a researcher working on something that could genuinely shape a real decision, the data behind it deserves that same level of scrutiny. Start collecting field data for free book a demo with us demo.wecollect.tech or just check out the system your self www.wecollect.tech


Further Reading

World Economic Forum (2013). A brief guide to the Reinhart-Rogoff discussion.

Herndon, T., Ash, M., & Pollin, R. (2013). Does High Public Debt Consistently Stifle Economic Growth? A Critique of Reinhart and Rogoff. Political Economy Research Institute, University of Massachusetts Amherst.

Reinhart, C. & Rogoff, K. (2010). Growth in a Time of Debt. American Economic Review.

Leave a Comment

Your email address will not be published. Required fields are marked *

Save to list

Scroll to Top