PsiResample (data)
PsiResample returns an array of sample data; to use it, you must ‘array-enter’ a formula using this function. For example, you might select cells A1:A5, type a formula such as =PsiResample(Z1:Z1000), and press Ctrl + Shift + Enter. The formula will then appear in all five cells A1:A5 as {=PsiResample(Z1:Z1000)}. On each Monte Carlo trial, the function will return 5 sample values.
PsiResample returns a random sample (with replacement) 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 PsiResample is array-entered is a single column, then PsiResample 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, PsiResample returns values from a randomly selected row in data, with values drawn sequentially from that row, beginning with the first element.