CELLS Subcommand (OLAP CUBES command)

By default, OLAP CUBES displays the means, standard deviations, number of cases, sum, percentage of total cases, and percentage of total sum.

• If CELLS is specified without keywords, OLAP CUBES displays the default statistics.
• If any keywords are specified on CELLS, only the requested information is displayed.

DEFAULT. Means, standard deviations, cell counts, sum, percentage of total N, and percentage of total sum. This is the default if CELLS is omitted.

MEAN. Cell means.

STDDEV. Cell standard deviations.

COUNT. Cell counts.

MEDIAN. Cell median.

GMEDIAN. Grouped median.

SEMEAN. Standard error of cell mean.

SUM. Cell sums.

MIN. Cell minimum.

MAx. Cell maximum.

RANGE. Cell range.

VARIANCE. Variances.

KURT. Cell kurtosis.

SEKURT. Standard error of cell kurtosis.

SKEW. Cell skewness.

SESKEW. Standard error of cell skewness.

FIRST. First value.

LAST. Last value.

SPCT. Percentage of total sum.

NPCT. Percentage of total number of cases.

SPCT(var). Percentage of total sum within specified variable. The specified variable must be one of the grouping variables.

NPCT(var). Percentage of total number of cases within specified variable. The specified variable must be one of the grouping variables.

HARMONIC. Harmonic mean.

GEOMETRIC. Geometric mean.

ALL. All cell information.