Bernoulli Distribution in Google Sheets
Binary outcomes: win or lose, ship or slip, pass or fail.
Interactive Sandbox
10,000 simulations running live in your browser.
When to use it
The Bernoulli distribution models a single binary trial: success (1) with probability p, failure (0) with probability 1-p. It's the atom of risk modeling — every coin flip, deal close, launch go/no-go, or system pass/fail is a Bernoulli trial. Chain them together in a Monte Carlo model to simulate the probability of hitting N successes out of M trials, or to weight scenarios by their likelihood of occurring.
- Deal close probability in sales pipeline simulations
- Go/No-Go decision weighting in project risk models
- Product launch success/failure scenario modeling
- Binary event triggers in compound risk models
How to build it
Native Sheets Formula
=IF(RAND() < p, 1, 0) Using native RAND() requires you to copy this formula 10,000 times manually, which severely lags the browser.
The MonteSheet Way
MonteSheet uses a local browser engine to run 100,000 iterations in 4 seconds without writing a single formula.
Explore more distributions
The bell curve that powers every financial forecast.
For anything that can't go below zero — prices, durations, deal sizes.
Minimum, most likely, maximum — the analyst's fast estimate.
The project manager's secret weapon.
Every outcome equally likely — maximum uncertainty.
Model probabilities, percentages, and win rates.