NxShuffle - Shuffle the order of elements in a data set

Returns a randomly shuffled order of elements in the input data set.

Syntax

NxShuffle(X, Seed, KeepNA)

X

is the input data sample (one/two-dimensional array of cells (e.g., rows or columns)).

Seed

is the seed value (positive integer) of the random number generator. If missing or zero(0), a random number from the CPU clock is used.

KeepNA

is a flag for leaving (or purging) observations with missing values (e.g., #N/A, #VALUE!, #NUM!, empty cell) found in the input data set. If missing, keepNA=False.

Remarks

1. The input data set may span multiple rows and/or columns, but the result is always a one-dimensional array (i.e. column).
2. If the keepNA argument is set to False(0), observations with missing values (e.g. #N/A, #VALUE!, #NUM!, empty cell) in the input data set are purged prior to the shuffling.
3. The returned array has the same size as the input data set minus the number of observations with missing values (e.g. #N/A, #VALUE!, etc.).
4. For a seed value of zero(0), the NxShuffle will generate a random number from the machine clock, thus, returning different ordered elements set for each run.
5. For negative seed value, NxShuffle returns #VALUE!.
6. The NxShuffle function is available starting with version 1.66 PARSON.

Files Examples

Related Links

• Wikipedia - Statistical Sampling.

References

• D. S.G. Pollock; Handbook of Time Series Analysis, Signal Processing, and Dynamics; Academic Press; Har/Cdr edition(Nov 17, 1999), ISBN: 125609906.
• James Douglas Hamilton; Time Series Analysis; Princeton University Press; 1st edition(Jan 11, 1994), ISBN: 691042896.
• Tsay, Ruey S.; Analysis of Financial Time Series; John Wiley & SONS; 2nd edition(Aug 30, 2005), ISBN: 0-471-690740.
• Box, Jenkins and Reisel; Time Series Analysis: Forecasting and Control; John Wiley & SONS.; 4th edition(Jun 30, 2008), ISBN: 470272848.
• Walter Enders; Applied Econometric Time Series; Wiley; 4th edition(Nov 03, 2014), ISBN: 1118808568.