Calculation guide
This uses the lower median at an exact tie.
median = smallest return with cumulative weight ≥ ½ total
Inputs
Scenario return (%)
Example entry 3 %. Allowed range -100.0 to 100000.0.
Relative probability weight
Example entry 1.
Worked example
Scenario returns and weights
| Scenario return (%) | Relative probability weight |
|---|---|
| -5% | 1 |
| 3% | 3 |
| 8% | 1 |
| Result | Value |
|---|---|
| Weighted median return | 3% |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Scenario return (%) (row 2) | 3% | 4% | Weighted median return | 3% | 4% |
| Relative probability weight (row 2) | 3 | 0 | Weighted median return | 3% | -5% |
