VoseLargestSet

MR_dice_icon.jpg Download a complete copy of this risk analysis resource for free here.

 

VoseLargestSet(Distribution,n)image928.gif

 

 

1Excel_icon.gif 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.

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.