CELLS Subcommand (SUMMARIZE command)

By default, SUMMARIZE displays the means, standard deviations, and cell counts in each cell. Use CELLS to modify cell information.

• If CELLS is specified without keywords, SUMMARIZE displays the default statistics.
• If any keywords are specified on CELLS, only the requested information is displayed.
• MEDIAN and GMEDIAN use a lot of computer resources and time. Requesting these statistics (via these keywords or ALL) may slow down performance.

DEFAULT. Means, standard deviations, and cell counts. This setting 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 control variables.

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

HARMONIC. Harmonic mean.

GEOMETRIC. Geometric mean.

ALL. All cell information.