CELLS Subcommand (MEANS command)

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

  • If CELLS is specified without keywords, MEANS displays the default statistics.
  • If any keywords are specified on CELLS, only the requested information is displayed.
  • MEDIAN and GMEDIAN are expensive in terms 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 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.

NPCT. Percentage of the total number of cases.

SPCT. Percentage of the total sum.

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

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

HARMONIC. Harmonic mean.

GEOMETRIC. Geometric mean.

ALL. All cell information.