An uncertain spreadsheet for estimates

Posted to Apps  |  Tags: ,  |  Nathan Yau

A lot of data you get are estimates with uncertainty attached. Plus or minus something. Standard error. So when you try to do math with those numbers straight up, ignoring the uncertainty, you end up with a result that seems concrete but it’s actually more squishy.

Guesstimate, made by Ozzie Gooen, is an effort to include the uncertainty in your spreadsheets.

The first reaction of many people to uncertain math is to use the same techniques as for certain math. They would either imagine each unknown as an exact mean, or take ‘worst case’ and ‘best case’ scenarios and multiply each one. These two approaches are quite incorrect and produce oversimplified outputs.

Guesstimate works like a regular spreadsheet where you input numbers into cells. But you can also include the uncertainty estimates, which is where it gets interesting. Piece together cells, and then using a Monte Carlo method, Guesstimate generates a new estimate with its own uncertainty.

Give it a go.

Favorites

How You Will Die

So far we’ve seen when you will die and how other people tend to die. Now let’s put the two together to see how and when you will die, given your sex, race, and age.

Jobs Charted by State and Salary

Jobs and pay can vary a lot depending on where you live, based on 2013 data from the Bureau of Labor Statistics. Here’s an interactive to look.

Who is Older and Younger than You

Here’s a chart to show you how long you have until you start to feel your age.

The Best Data Visualization Projects of 2014

It’s always tough to pick my favorite visualization projects. Nevertheless, I gave it a go.