Statistical construction error

August 20, 2011

Yes, the title is meant to have two readings.

The effect

The Numbers Guy, among other examples, talks about the UK Office for National Statistics needing to revise its estimate for the construction sector output because of an error.

Original: 2.3% growth

Corrected: 0.5% growth

Here is the Telegraph article cited by The Numbers Guy.

The cause

The spreadsheet that is used to calculate the statistic was not updated properly.

Questions

Have they not read “Spreadsheet Addiction”?

Why are they not using R?

Does this scare anybody else?

Epilogue

Who would take the repercussions when the bottle is to blame?

from “Down the Mountain” by Robin E. Contreras

Subscribe to the Portfolio Probe blog by Email

Leave a Reply

Related posts

  • May 15, 2013

    Torturing portfolios to give different volatilities between a factor model and Ledoit-Wolf shrinkage. Previously There have been posts on: "What the hell is a variance matrix?" factor models Ledoit-Wolf [...]

  • May 6, 2013

    What's that thing about arithmetic and geometric returns and the variance? Previously An introduction to the difference between simple and log returns is: A tale of two returns Issue [...]

  • April 29, 2013

    When investment skill is simulated, it is often presented as if it is obvious how to do it.  Maybe I'm wrong, but I don't think it's obvious. Previously In [...]