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

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->