Weighted median return from scenario probabilities · Calculation guide

Sort returns from low to high and choose the first whose cumulative weight reaches half the total.

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
ResultValue
Weighted median return3%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Scenario return (%) (row 2)3%4%Weighted median return3%4%
Relative probability weight (row 2)30Weighted median return3%-5%
Weighted median return from scenario probabilities →

Sources