Discrete Uniform Distribution in Google Sheets
Equal odds across a fixed set of whole-number outcomes.
Interactive Sandbox
10,000 simulations running live in your browser.
When to use it
The Discrete Uniform distribution assigns equal probability to every integer from a minimum to a maximum. Use it when outcomes are countable and there's no reason to prefer one over another: rolling a die, picking a random scenario from an equally-weighted list, or modeling regulatory outcomes that are discrete but hard to rank. It's the integer sibling of the Uniform distribution.
- Scenario selection when outcomes are discrete and equally likely
- Die-roll / game mechanics simulation
- Random assignment and random sampling in bootstrapped models
- Stress-testing with equally-weighted regulatory scenarios
How to build it
Native Sheets Formula
=RANDBETWEEN(min, max) 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.