Tag Archives: probability

How to decide (fairly) where to grab lunch with friends

Taking a walk and grabbing lunch is one of the simple pleasures of the workday. Unless of course, you bring your lunch to work. Sometimes with a group of people it is hard to decide on where everyone should go to lunch together. Maybe only one person enjoys the guilty pleasure of Taco Bell, while the others want to stick with Whole Foods. Or maybe half of the group wants burgers and the other half pizza.

imageimage

Here’s a relatively simple Google Mobile spreadsheet. It’s part 2 of our mobile phone spreadsheet series (See Part 1 on Tracking New Year’s Resolutions) that uses a weighted lottery to fairly determine where to go for lunch, taking into account each person’s individual preferences. Basically, each person gets 10 “points” to allocate to three restaurant choices. Each point is effectively a lottery ticket, and the spreadsheet randomly chooses the restaurant, with the probability weighted by how many points each restaurant has received. Continue reading

Monte Carlo Simulation – Fantasy Football playoff predictor

How likely will you make the fantasy football playoffs? It’s week 11 of the Fantasy Football season, which means there’s only three more weeks until the Fantasy Football playoffs. All your hard work up to this point – drafting your team, closely following daily fantasy football podcasts and injury reports, and agonizing over who to play in your Flex spot – rests upon what happens in these next few weeks. Continue reading

What are the chances a Little League baseball player gets to the Major Leagues someday?

baseballIt’s that time of the year when Little League World Series coverage heats up on ESPN, and viewers get to see a miniaturized version of baseball played at the highest level. This year has been especially impressive with a super-team from Las Vegas that rarely makes errors, the Chicago team that beat them, and of course the sensational female pitcher Mo’ne Davis, who throws as hard as some high school pitchers. Every Little Leaguer dreams of making it to the big leagues, someday making a career of playing the game they love.  But how hard is it to get there? This is a question that we will try to solve this week with the help of a spreadsheet.

Continue reading

Probabilities & Dice Roll Simulations in Spreadsheets

Dice

Photo: Amie Chuang

What is the probability of rolling any pair of numbers with two dice? Let’s first solve this and then confirm our calculated probability by simulating 500 dice rolls with a spreadsheet! In this post, we will focus on understanding basic probability concepts and then discover how with spreadsheets, we can actually see whether our calculated probability holds true!

Continue reading