VoseRank

See also: VoseSortA, VoseSortD

VoseRank({data}, descending)

 

 

Example model-1, Example model-2

This array function returns an array with the ranks of the values from the input array. By default, the ranks in the list are sorted in ascending order, meaning that rank 1 is given to the lowest value.

When duplicates occur in the data, all of them are assigned the average of their ranks (which is more correct than Excel's RANK function that assigns the highest rank.)

  • {data} - the data of which the ranks are to be determined.

  • Descending - optional boolean parameter. Set FALSE (default) for ascending ranks, i.e. 1 = lowest data value. Set TRUE for descending ranks, i.e. 1 = highest data value.

When the output array is smaller in size than the {data} array, say n cells, only the ranks of the first n values of the input array are returned.

When the output array is larger in size than the {data} array it will return the ranks and fill up the remaining part of the output with #N/A errors.

 

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