User Guide

352
Chapter 19
OLAP Cubes St
atistics
Figure 19-3
OLAP Cubes Statistics dialog box
You can choose one or more of the following subgroup statistics for the summary
variables within each category of each grouping variable: sum, number of cases,
mean, me
dian, grouped median, standard error of the mean, minimum, maximum,
range, variable value of the first category of the grouping variable, variable value of
the last category of the grouping variable, standard deviation, variance, kurtosis,
standa
rd error of kurtosis, skewness, standard error of skewness, percentage of total
cases, percentage of total sum, percentage of total cases within grouping variables,
percentage of total sum within grouping variables, geometric mean, and harmonic
mean.
You can change the order in which the subgroup statistics appear. The order in
which the statistics appear in the Cell Statistics list is the order in which they are
displ
ayed in the output. Summary statistics are also displayed for each variable
across all categories.
First. Displays the first data value encountered in the data file.
Geometric Mean. Thenthrootoftheproductofthedatavalues,wherenrepresentsthe
numb
er of cases.