User Guide

353
OLAP Cubes
Grouped Median. Median calculated for data that is coded into groups. For example,
with age data if each value in the 30's is coded 35, each value in the 40's coded 45,
andsoon,th
e grouped median is the median calculated from the coded data.
Harmonic Mean. Used to estimate an average group size when the sample sizes in the
groups are not equal. The harmonic mean is the total number of samples divided by
the sum of th
e reciprocals of the sample sizes.
Kurtosis. A measure of the extent to which observations cluster around a central point.
For a normal distribution, the value of the kurtosis statistic is 0. Positive kurtosis
indicates
that the observations cluster more and have longer tails than those in the
normal distribution and negative kurtosis indicates the observations cluster less
and have shorter tails.
Last. Disp
lays the last data value encountered in the data file.
Maximum. Thelargestvalueofanumericvariable.
Mean. A measure of central tendency. The arithmetic average; the sum divided
by the numb
er of cases.
Median. The value above and below which half the cases fall, the 50th percentile. If
there is an even number of cases, the median is the average of the two middle cases
when they
are sorted in ascending or descending order. The median is a measure of
central tendency not sensitive to outlying values--unlike the mean, which can be
affected by a few extremely high or low values.
Minimum.
The smallest value of a numeric variable.
N. The number of cases (observations or records).
Percent of N in. Percentage of the number of cases for the specified grouping variable
within c
ategories of other grouping variables. If you only have one grouping variable,
this value is identical to percentage of total number of cases.
Percent of Sum in. Percentage of the sum for the specified grouping variable within
categor
ies of other grouping variables. If you only have one grouping variable, this
value is identical to percentage of total sum.
Percent of Total N. Percentage of the total number of cases in each category.
Percent
of Total Sum.
Percentage of the total sum in each category.