Your regret table will appear here
The result will calculate the avoidable gap for both options in every scenario, then compare maximum and average regret.
How regret is calculated
Within each scenario, the better entered result becomes the benchmark. Regret equals that benchmark minus the option's result. The scenario winner has zero regret, while the other option shows the value it leaves behind.
What minimax regret protects
Minimax regret compares each option's largest regret and favors the smaller one. It is useful when the scenarios are meaningful but their probabilities are too weak for an expected-value calculation. It does not predict which future will occur, and it does not measure emotional disappointment.
Worked capacity example
A larger facility returns 70 under low demand, 110 under expected demand, and 160 under high demand. A smaller facility returns 90, 105, and 120. The large facility's regrets are 20, zero, and zero. The small facility's regrets are zero, 5, and 40. Minimax regret favors the larger facility because its worst avoidable gap is 20 rather than 40. If a value below 80 would be unaffordable, however, the large facility fails the downside requirement before regret is considered.
Use scenarios that share a cause
- Name an external condition rather than writing one favorable story for each option.
- Keep time horizon, currency, and included costs consistent.
- Use values that represent outcomes, not subjective confidence scores.
- Record the first assumption that would materially change the largest regret.
If scenario probabilities become defensible, compare the result with the expected value calculator. If downside boundaries matter more than opportunity gaps, use the decision risk range calculator.