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.
Remarks
- 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.
Files Examples
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