You can add columns of descriptive summary statistics for any numeric column in the source table by clicking the Statistics button (Adding Summary Statistics) and making a selection from the menu.
The Statistics menu gives these summary statistics for numeric columns:
•

N Is the number of nonmissing values.

•

Mean Is the arithmetic mean of a column’s values. It is the sum of nonmissing values (and if defined, multiplied by the weight variable) divided by the Sum Wgt.

•

Std Dev Is the sample standard deviation, computed for the nonmissing values. It is the square root of the sample variance.

•

Min Is the smallest nonmissing value in a column.

•

Max Is the largest nonmissing value in a column.

•

•

% of Total Is the percent of the total count for each group. Or, if you have so specified, the percent of nonmissing values of the column to the total count for each group.

•

N Missing Is the number of missing values.

•

N Categories Is the number of distinct categories.

•

Sum Is the sum of all values in a column.

•

Sum Wgt Is the sum of all weight values in a column. (See Assign Column Properties in Set Column Properties.) Or, if no column is assigned the weight role, Sum Wgt is the total number of nonmissing values.

•

Variance Is the sample variance, computed for the nonmissing values. It is the sum of squared deviations from the mean, divided by the number of nonmissing values minus one.

•

Std Err Is the standard error of the mean. It is the standard deviation divided by the square root of N. If a column is assigned the role of weight, then the denominator is the square root of the sum of the weights.

•

CV (Coefficient of Variation) Is the measure of dispersion, which is the standard deviation divided by the mean multiplied by one hundred.

•

Median Is the 50th percentile, which is the value where half the data are below and half are above or equal to the 50th quantile (median).

•

Interquartile Range Is the difference between the third and first quartiles.

•

Quantiles Gives the value at which the specific percentage of the argument is less than or equal to. For example, 75% of the data is less than the 75th quantile. The summary window has an edit box for entering the quantile percentage that you want.
