Excel Error Economic Paper Text

Jonathan Friesen - Writing Coach

Aurich lawson an economics paper claiming that high levels of national debt led to low or negative economic growth could turn out to be deeply flawed as a result of, among other things, an incorrect formula in an excel spreadsheet. Microsoft's powerpoint has been considered evil thanks to the proliferation of poorly presented data and dull slides that are created with it. Might excel also deserve such hyperbolic censure? the paper, growth in a time of debt. Was written by economists carmen reinhart and kenneth rogoff and published in 2010. Since publication, it has been cited abundantly  by the world's press politicians, including one time vice president nominee paul ryan r wi. the link it draws between high levels of debt and negative average economic growth has been used by right leaning politicians to justify austerity budgets: slashing government expenditure and reducing budget deficits in a bid to curtail the growth of debt. This link was always controversial, with many economists proposing that the correlation between high debt and low growth was just as likely to have a causal link in the other direction to that proposed by reinhart and rogoff: it's not that high debt causes low growth, but rather that low growth leads to high debt.

College Research Paper on Adhd

However, the underlying numbers and the existence of the correlation was broadly accepted, due in part to reinhart and rogoff's paper not including the source data they used to draw their inferences. Thomas herndon, michael ash, and robert pollin of the university of massachusetts, amherst, tried to reproduce the reinhart and rogoff result with their own data, but they couldn't. So they asked for the original spreadsheets that reinhart and rogoff used to better understand what they were doing.

Their results, published as does high public debt consistently stifle economic growth? a critique of reinhart and rogoff , suggest that the pro austerity paper was flawed. A comprehensive assessment of the new paper can be found at the rortybomb economics blog. It turns out that the reinhart and rogoff spreadsheet contained a simple coding error.

The spreadsheet was supposed to calculate average values across twenty countries in rows 30 to 49, but in fact it only calculated values in 15 countries in rows 30 to 44. There was also a pair of important, but arguably more subjective, errors in the way the data was processed. Reinhart and rogoff excluded data for some countries in the years immediately after world war ii.

The uk's 19 year stretch of high debt and moderate growth during the period between 1946 and 1964, the debt to gdp ratio was above 90 percent, and growth averaged 2.4 percent is conflated into a single data point and treated as equivalent to new zealand's single year of debt above 90 percent, during which it experienced growth of 7.6. Some kind of weighting system might be justified, with herndon, ash, and pollin speculating that there is a serial correlation between years. Recalculating the data to remove these three issues turns out to provide much weaker evidence for austerity.

Ebook on English Essays

Although growth is higher in countries with a debt ratio of less than 30 percent averaging 4.2 percent , there's no point at which it falls off a cliff and inevitably turns negative. For countries with a debt of between 30 and 60 percent, average growth was 3.1 percent, between 60 and 90 it was 3.2 percent, and above 90 percent it was 2.2 percent. Lower than the low debt growth, but far from the 0.1 percent growth the original paper claimed. As such, the argument that high levels of debt should be avoided and the justification for austerity budgets substantially evaporates. whether politicians actually  used this paper to shape their beliefs or merely used its findings to give cover for their own pre existing beliefs is hard to judge. Excel is used extensively in fields such as economics and finance, because it's an extremely useful tool that can be deceptively simple to use, making it apparently perfect for ad hoc calculations. However, spreadsheet formulae are notoriously fiddly to work with and debug, and excel has long standing deficiencies when it comes to certain kinds of statistical analysis. It's unlikely that this is the only occasion on which improper use of excel has produced a bad result with far reaching consequences.

Bruno iksil, better known as the london whale, racked up billions of dollars of losses for bank jpmorgan. Including manual copying and pasting between workbooks and a number of formula errors that resulted in underestimation of risk. It was included as a papers and proceedings article, taken from a conference and published without being reviewed. A peer reviewer might have sought the excel spreadsheet at review time and could have exposed these flaws sooner. In turn, this may have prevented an apparently flawed paper from receiving the widespread attention that it got.

april 18, 2013 by nancy owano weblog
phys.org required reading for those examining the cause and effect of bread lines: two papers, one published in 2010 and the other published just this month, poking holes into the 2010 study and inciting a global wave of publicity. By harvard economists carmen reinhart and kenneth rogoff, growth in a time of debt.

Hindi Essays for Class 10Th

Claimed that as countries see debt/gdp going above 90 percent, growth slows dramatically: high levels of national debt lead to low or negative economic growth. The paper was supported by those involved in policy debates from the u.s, to europe, calling for austerity measures as a panacea to balance budgets and ease high levels of national debt, turning back a perceived tide of continued negative economic growth. This month, however, university of massachusetts academics said the 2010 study had errors. The real headline maker by those viewing the new study turned out to be that, among the weaknesses found, was a coding error in excel. The new report is a turning point in long standing controversy over the 2010 paper, as other economists sought to replicate the results drawn in the two authors' presentation, yet they were unable to do so.

Essay About Love of Country

A critique of reinhart and rogoff, by thomas herndon, michael ash, and robert pollin, figured out why other scholars had such a difficult time replicating the results. Examining the data spreadsheet used in the 2010 study, the university of massachusetts authors discovered several flaws. The excel error was not the primary problem but part of a number of weaknesses, according to the three authors. In addition to the excel spreadsheet errors, they said they identified excluded data, and what they said were unusual weightings of statistics from which the two authors' conclusions were drawn.

The abstract of the newly published paper said, herndon, ash and pollin replicate reinhart and rogoff and find that coding errors, selective exclusion of available data, and unconventional weighting of summary statistics lead to serious errors that inaccurately represent the relationship between public debt and gdp growth among 20 advanced economies in the post war period. In addition, the authors wrote that, overall, the evidence we review contradicts reinhart and rogoff's claim to have identified an important stylized fact, that public debt loads greater than 90 percent of gdp consistently reduce gdp growth. At the same time, one of the co authors, ash, told businessweek that the new paper. In examining the 2010 study, did indicate a modest diminishment in growth in countries suffering large debts but not like the stagnation or decline in the study by the harvard authors. Rogoff and reinhart acknowledged the excel spreadsheet mistake: herndon, ash and pollin accurately point out the coding error that omits several countries from the averages in figure 2.