« The mirage of large numbers | Main | FDA endorses masking placebos as proven drugs as a get-rich-quick scheme »


Feed You can follow this conversation by subscribing to the comment feed for this post.


At one time I did simulations in Excel, and it becomes difficult when they are large and changes need to be made. When there are a lot of cells needing to be changed, you need to keep good records of what each does, as until you click on them there is no idea what any of them are doing. It is a mess.

The problem with these simplistic economic analyses is that they don't correct for everything. Economies have lags in anything up to decades, they have structural problems that need to be identified, and economists generally don't believe that private debt matters, so they ignore it.


Ken: Absolutely agree with you on the simplistic analysis with no controls at all. That explains why Freakonomics was so valued in the economics community - it is an attempt to find datasets with proper control groups.

Yes, and even if you simulate your own data, there could be bugs in the code, or other problems. So I should take out that caveat.

Tom from the Bronx

I'm just a lowly number cruncher in the policy world, but when I calculate the same quantity under four conditions, and it's the same in three cases but different in the fourth, my very first thought is always that I have Excel summing over the wrong range in the different one.

The comments to this entry are closed.

Get new posts by email:
Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR, Wired.

See my Youtube and Flickr.


  • only in Big Data
Numbers Rule Your World:
Amazon - Barnes&Noble

Amazon - Barnes&Noble

Junk Charts Blog

Link to junkcharts

Graphics design by Amanda Lee

Next Events

Jan: 10 NYPL Data Science Careers Talk, New York, NY

Past Events

Aug: 15 NYPL Analytics Resume Review Workshop, New York, NY

Apr: 2 Data Visualization Seminar, Pasadena, CA

Mar: 30 ASA DataFest, New York, NY

See more here

Principal Analytics Prep

Link to Principal Analytics Prep