« 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.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)

Business analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Next Events

Feb: 11 JMP Explorers Seminar, Marlow, UK
Streaming link

Apr: 10-12 INFORMS Analytics Conference, Orlando, FL

Apr: 21 UMSL Digital Media Marketing Conference, St. Louis

Past Events

See here

Future Courses (New York)

Spring: Statistical Reasoning & Numbersense, rSQUAREedge (4 weeks)

Summer: Applied Analytics Frameworks & Methods, Columbia (6 weeks)

Junk Charts Blog

Link to junkcharts

Graphics design by Amanda Lee


  • only in Big Data