NxFold - Convert a 3 columns into a 2-D table or matrix

Converts a 3-columns representation (i.e., X, Y, and Z) into a two-dimensional table.

Syntax

NxFold(X, Y, Z, X-Levels, Y-Levels, KeepNA)

X

is a range of cells (one-dimensional array) of the 1st variable (X) - independent.

Y

is a range of cells (one-dimensional array) of the 2nd variable (Y) - independent.

Z

is a range of cells (one-dimensional array) of the 3rd variable (Z) - dependent.

X-Levels

is a one-dimensional array of cells (e.g., rows or columns) for corresponding desired output levels/values of X (1st variable) in the data table. If missing or omitted, all levels found in X are assumed.

Y-Levels

is a one-dimensional array of cells (e.g., rows or columns) for corresponding desired output levels/values of Y (2nd variable) in the data table. If missing or omitted, all levels found in Y are assumed.

KeepNA

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

Remarks

1. The NxFold function must be entered as an array formula in a two-dimensional cell range with the same number of rows as X-levels, and the same number of columns as Y-Levels.
2. Use NxFold to transform the representation or the format of a 3D data set (X, Y, Z) into a tabular form suitable for data visualization (i.e., plotting) and/or interpolation.
3. The observations in X, Y, and Z can have any order and are not assumed to be sorted.
4. The X and/or Y arrays may have missing values (#N/A). In this case, NxINTRPL will remove those entries.
5. The Z arrays may have missing values (#N/A). NxFold keeps/removes those entries based on the "KeepNA" flag setting, only if corresponding X and Y values are given (i.e., not missing).
6. The X-Levels and Y-Levels may have missing values (#N/A), In this case, NxFold will remove those entries.
7. The X-Levels and Y-Levels can have any order, no sorting is required.
8. The values in X-Levels must be unique, duplicate values, if found, are removed.
9. The values in Y-Levels must be unique, duplicate values, if found, are removed.
10. The NxFold() function is available starting with version 1.66 PARSON.

Files Examples

References

• John Walkenbach (2002). Excel charts. Wiley. ISBN 978-0764517648.