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
- The input data set may span multiple rows and/or columns, but the result is always a 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 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
Related Links
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.
Comments
Article is closed for comments.