VoseExtremeRange | Vose Software


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.



Monte Carlo simulation in Excel. Learn more

Spreadsheet risk analysis modeling


Adding risk and uncertainty to your project schedule. Learn more

Project risk analysis


Enterprise Risk Management software (ERM)

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

Enterprise risk management software introduction