Uniform Distribution in Google Sheets
Every outcome equally likely — maximum uncertainty.
Interactive Sandbox
10,000 simulations running live in your browser.
When to use it
The Uniform distribution assigns equal probability to every value between a minimum and maximum. It's the right choice when you have absolutely no reason to favor one outcome over another within a range: regulatory fee ranges, bid prices in a sealed auction, or any scenario where all you can say is 'it'll be somewhere between X and Y.' It's also used as a building block inside other distributions.
- Regulatory fee or tax rate uncertainty within a legislated range
- Raw material price bounds when market is thin
- Random tie-breaking and sampling in sensitivity analysis
- Worst-case / best-case bounding analysis
How to build it
Native Sheets Formula
=a + RAND() * (b - a) 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.
Model probabilities, percentages, and win rates.
Count how many times something rare will happen.
Binary outcomes: win or lose, ship or slip, pass or fail.
Equal odds across a fixed set of whole-number outcomes.