VoseLargestSet

 

VoseLargestSet(Distribution,n)

 

 

Example model

Array function that returns the k largest values out of n sampled values from the chosen distribution. The output should be 1 x k or k x 1 array. k should be smaller or equal to n.

  • distribution - A distribution object

  • n - the number of samples to be taken from the distribution

For example, if one selects 10 cells and types the formula =VoseLargestSet("VoseNormal(5,2)",100), the 10 biggest values are returned from 100 sampled values from a Normal distribution with mean 5 and standard deviation 2.

Also see the Vose Extreme Values window for an explanation about the window for this function.

 

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
-->