NxShuffle - Shuffle the order of elements in data set

Mohamad

June 14, 2019 18:13

Returns a randomly shuffled the 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.

The input data set may span multiple rows and/or columns, but the results is always one-dimensional array (i.e. column).
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.
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.).
For a seed value of zero(0), the NxShuffle will generate a random number from the machine clock , thus, returning a different ordered-elements set for each run.
For negative seed value, NxShuffle returns #VALUE!
The NxShuffle function is available starting with version 1.66 PARSON.

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