SampleValue.Weighted
RiskAMP Random Distribution Functions
Using this function in Excel:
=SampleValue.Weighted(Data, Weights)
Function arguments:
Data | Range of values to sample |
Weights | Range of weights |
Returns a sample from the Data
range, weighted according to values in
the Weights
range. These ranges must be the same size. The Weights
range
can use any values; it does not need to add up to 1 or 100.