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.