RiskAMP.Permutation

RiskAMP Random Distribution Functions

Using this function in Excel:


=RiskAMP.Permutation(Range of values)

Function arguments:

Range of values

Sample data

In each trial, this function returns the original sample data in randomly-sorted order.

This is an array function. You can enter it in a range of cells using Ctrl + Shift + Enter, or you can enter it into a single cell and use Excel’s spill function.

If you enter this function into a range of cells, the range should be the same shape (same number of rows and columns) as the original data.