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

Latest posts

Leave a Reply

Related posts

  • The devil of overfitting

    March 28, 2011

    Overfitting is a problem when trying to predict financial returns.  Perhaps you've heard that before.  Some simple examples should clarify what overfitting is -- and may surprise you. Polynomials [...]

  • Factor models of variance in finance

    March 7, 2011

    In "What the hell is a variance matrix?" I talked about the basics of variance matrices and highlighted challenges for estimating them in finance.  Here we look more deeply [...]

  • 4 and a half myths about beta in finance

    February 8, 2011

    Much of what has been said and thought about beta in finance is untrue. Myth 1: beta is about volatility This myth is pervasive. Beta is associated with the [...]