How simple rules can help avoid Piketty-style spreadsheet mistakes
23 May 2014 8:31pm
Economist Thomas Piketty has come under attack today. And this time it's not for his ideas, but the quality of his spreadsheets.
The Financial Times' Chris Giles has gone through the data published by the French economist, and found a range of errors.
When corrected for, the picture of wealth inequality painted by Piketty changes, especially for the UK.
The errors presented by Giles - including fat fingers and formula errors - are by no means the first high profile mistakes of their kind. Used in the wrong hands, Excel can be dangerous. It's incredibly powerful, the downside of which seems to be that novices can make some awful mistakes.
Economists Reinhart and Rogoff found themselves corrected when their spreadsheets were reviewed by students attempting to duplicate their findings in May of last year. That mistake undermined their work on national debts and growth.
Faulty Excel practices also take a lot of the blame for JP Morgan's huge London Whale trades. Errors in a model designed to evaluate value-at-risk (VaR) likely had the effect of "muting volatility by a factor of two and of lowering the VaR".
These are largely human errors. JP Morgan's faulty VaR model included a formula which divided by the sum of two quantities, rather than their average, as the modeler had intended.
But such mistakes can be avoided, or at least the risks of making them can be minimised, by establishing good rules of spreadsheet practice.
One huge problem with Piketty's spreadsheet work is in the way he adds adjustments. The unrounded values for the values in the yellow column below have been transplanted to the right. Note the inclusion of hardcoded adjustments.
Users shouldn't build spreadsheets relying on the idea that they'll make no mistakes. Such manual adjustments make it easier to mess up, and much harder to trace errors, let alone for someone to understand what's going on.
And that's why it's so important to establish consistent and simple formatting in your spreadsheets. If it's not obvious how steps are made, it can be incredibly difficult for others to review your work, and spot mistakes.
One way of doing this is to construct your sheets so that all calculations can be discerned from a print out of your file. Other basic steps include clear colour coding, so that cells performing different functions can be categorised clearly by their shade.
In other news
Tonight is the 60th Eurovision Song Contest, and once again we're in for an evening of cheesy music and crazy [Read more]
The Eurovision Song Contest is getting more and more expensive, despite Europe's decline into austerity [Read more]
There were delays of up to 30 minutes to trains in and out of Kings Cross Station, after the station was re-opened [Read more]
When a 20-year-old footballer publicly declares he wants to leave a club and his agent hurls insults at one of [Read more]
The outbreak of bird flu in the US is leading to an unprecedented situation for companies reliant on eggs – [Read more]
Germany's finance ministry has denied reports it was considering offering Greece its own parallel currency. [Read more]
Chancellor George Osborne was given a boost today, as higher tax receipts helped shrink the deficit by more than [Read more]
Beleaguered spread-betting firm Plus500 today suspended trading in its shares on London's junior market, following [Read more]
The news that card and electronic transactions have overtaken cash as the UK’s preferred method of payment is [Read more]
Despite the crippling effect of election uncertainty, offers received in April were up 15 per cent on last year [Read more]
Former secretary of state for communities and local government Eric Pickles is to be knighted, 10 Downing Street [Read more]
Network Rail engineers have destroyed the Abbey Wood station as part of the Crossrail development that is expected [Read more]
The Championship looks set to once again be named the fourth most-watched league in Europe, following a seven [Read more]
The Costa Coffee owner said Brittain was "the standout candidate from a very strong field". [Read more]
Sugary foods may be taxed to cover the costs of treating obesity, a government minister has said.
European governments must increase efforts to adopt structural reform if “lasting stability and prosperity” [Read more]
Accounting, finance and economics - choose to study any of these subjects anywhere and you'll be likely to land [Read more]
Badly-behaved bosses are a nightmare if you're the unfortunate employee who has to work for them - but they're [Read more]