VoseExtremeRange | Vose Software

VoseExtremeRange

See also: Vose Extreme Values window, VoseLargest, VoseSmallest

VoseExtremeRange(Distribution, N)

 

 

 

Array function that simulates the lowest and highest values of a set of N independent observations drawn from a distribution.

  • Distribution - a valid distribution object

  • N - the number of observations drawn from the distribution

Note that this function is not the same as writing VoseSmallest and VoseLargest in separate cells: the values generated by VoseExtremeRange come from the same set of N observations, whereas with VoseSmallest and VoseLargest the generated values would each come from their separate set of observations. The difference becomes clear if you consider low N values: for the extreme case of N=1, VoseExtremeRange will always return two identical values.

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Spreadsheet risk analysis modeling

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Project risk analysis

Navigation

Enterprise Risk Management software (ERM)

Learn more about our enterprise risk analysis management software tool, Pelican

Enterprise risk management software introduction