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

  • December 17, 2012

    Historical Value at Risk (VaR) is very popular because it is easy and intuitive: use the empirical distribution of some specific number of past returns for the portfolio. Previously [...]

  • December 10, 2012

    The Imperial College Algorithmic Trading Conference was Saturday. Talks Massoud Mussavian Massoud gave a great talk on "Algo Evolution".  It started with a historical review of how trading used [...]

  • December 6, 2012

    A simpler approach to producing the variability. Previously The post "Variability in long-short decile strategy tests" proposed a way of assessing the variability of strategy tests in which a [...]