PsiMVResample (data)
PsiMVResample is a multivariate distribution that returns a vector of sample data; to use it, you must ‘array-enter’ a formula using this function. The data argument must be an Excel range consisting of more than 1 row or column. This function may be array entered in a single column (or row) of size n where n is the number of rows (or columns) in the data argument.
PsiMVResample returns a random sample of the trial values in the cell range specified by the data argument. If data is a rectangular cell range and the cell range in which PsiMVResample is array-entered is a single column, then PsiMVResample returns values from a randomly selected column in data, with values drawn sequentially from that column, beginning with the first element. Similarly, if data is rectangular and the cell range is a single row, PsiMVResample returns values from a randomly selected row in data, with values drawn sequen¬tially from that row, beginning with the first element.
For example, you might select cells A1:A3 type a formula such as =PsiMVResample(D1:F3) and press Ctrl + Shift + Enter. The formula will then appear in all three cells A1:A3 as {=PsiMVResample(D1:F3)}. On each Monte Carlo trial, cells A1:A3 will return a uniformly selected column from the argument. Alternatively, you might select cells A1:C1 type a formula such as =PsiMVResample(D1:F3) and press Ctrl + Shift + Enter. The formula will then appear in all three cells A1:C1 as {=PsiMVResample(D1:F3)}. On each Monte Carlo trial, cells A1:C1 will return a uniformly selected row from the argument.