# What was the Rogoff & Reinhart spreadsheet mistake?

Economics Asked by csilvia on August 21, 2020

In class our professor said that the Rogoff and Reinhart research on growth and debt was discredited due to spreadsheet mistake. What was this mistake? Also did they perform their research in excel instead of R, stata or some other advanced program?

Reinhart and Rogoff (2010, RR) claimed that GDP growth is much lower when debt/GDP > 90%.

Herndon, Ash, and Pollin (2014, PDF, HAP) placed their errors into four categories:

1. Spreadsheet error: RR omitted Australia, Austria, Belgium, Canada and Denmark from the analysis (apparently a coding error somehow dropped the first five countries when sorted alphabetically).
2. One small transcription error: RR incorrectly transcribed a figure of "-7.6%" in one spreadsheet to "-7.9%" to another.
3. Inappropriate weighting: Example: New Zealand had only one year (1951) with debt/GDP > 90% and in 1951, its GDP growth was -7.6%. The UK had 19 years with debt/GDP > 90% and in those 19 years, its average GDP growth was 2.4%. The usual practice would be to count New Zealand 1951 as one country-year observation and those 19 UK years as 19 country-year observations. But instead, RR averaged the 19 UK years as one single observation that carried the same weight as that single New Zealand 1951 observation.
4. Selective exclusion of available data: Example. RR exclude Australia (1946–50), New Zealand (1946–49), and Canada (1946–50) without giving any explicit reason. But these country-year observations are precisely instances of high GDP growth and debt/GDP ratios.

Errors #1 and #2 are clear cut (and may be fairly characterized as "Excel spreadsheet errors").

Errors #3 and #4 are a little more subjective.

(Neither RR nor HAP state the program used. But as reported in e.g. NYMag, following repeated requests from Herndon, Reinhart emailed to Herndon an Excel file and it was in this file that Herndon discovered errors.)

Correct answer by Kenny LJ on August 21, 2020

The paper by Herndon et al. shows that there were "coding errors, selective exclusion of available data, and unconventional weighting of summary statistics". So it's a little deeper than a mere "spreadsheet error" and isn't software-specific, but the term makes good press. Herndon was interviewed on the Colbert Report and I believe that may be where the paper got popularly associated with that term.

Answered by Brian Z on August 21, 2020

## Related Questions

### Bondholder vs purchaser of bond

2  Asked on September 1, 2021 by harry

### Log-linearization of an intertemporal budget constraint

0  Asked on September 1, 2021 by bdvse

### Are quantitative easing and helicopter cash really different tactics? And how does QE relate to Modern Monetary Theory?

2  Asked on September 1, 2021

### What is steady state learning in the context of boundedly rational expectation modeling and how does it differ with other theories of learning?

0  Asked on September 1, 2021 by beck-batucada

### How do I figure out whether the ICs are convex or concave?

0  Asked on September 1, 2021 by mrap

### How could Euro bonds serve as a “safe haven” asset in the long run?

0  Asked on September 1, 2021 by arash-howaida

### What are the determinants of the natural rate of interest and how market rate converges to it?

2  Asked on September 1, 2021 by user28453

### Can an In the Money Put Option’s price $>$ its Strike Price?

1  Asked on September 1, 2021

### Are taxes,subsidies and social money transfers(i.e. welfare) accounted in money velocity?

1  Asked on September 1, 2021 by user161005

### Can an Out the Money put option’s price $>$ its Strike Price?

1  Asked on September 1, 2021

### How can non-US banks issue USD loans?

1  Asked on September 1, 2021 by elemolotiv

### Pure-Strategy Bayesian Nash equilibrium with general common prior

2  Asked on August 31, 2021 by justin-malik

### Does the concept of Capitalism increase the net wealth?

2  Asked on August 25, 2021 by akozi

### How can a government save, if it has deficit?

1  Asked on August 25, 2021

### How to determine covariant stationary values?

1  Asked on August 20, 2021

### How to optimize this dynamical system? Needing guidelines

0  Asked on August 20, 2021 by rlf

### Solving a HJB with additional constraints on control and state variables

0  Asked on August 20, 2021

### Is Adam Smith’s “stock” an archaic version of “capital”?

1  Asked on August 20, 2021

### Are business cycle fluctuations usually studied in a (New Keynesian) DSGE model, or can they also be studied in a growth model?

1  Asked on August 20, 2021

### Policy ineffectiveness proposition

0  Asked on August 20, 2021

### Ask a Question

Get help from others!