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

  • Asynchrony in market data

    November 21, 2011

    Be careful if you have global daily data. The issue Markets around the world are open at different times.  November 21 for the Tokyo stock market is different from [...]

  • Performance measurement is about decisions

    November 16, 2011

    The return of a hypothetical fund was 17.9% in 2010.  We want to know if that is good or bad. The benchmark method The assets in the portfolio are [...]

  • Another look at autocorrelation in the S&P 500

    November 11, 2011

    Casting doubt on the possibility of mean reversion in the S&P 500 lately. Previously A look at volatility estimates in "The mystery of volatility estimates from daily versus monthly [...]