Types of Summarizations for Tabulations

The Type of Summary drop-down in the Tabulation dialog contains a number of summarizations.

number of records The number of rows in each group. 
  • The number of rows includes those with N/A values.
% of total records The number of rows in each group as a percentage of all rows.
  •  The number of rows includes those with N/A values.
Note: The result is a whole number, not a fractional value. For instance, a result of 20% would be represented as 20, not 0.20.
fraction of total records The number of rows in each group as a fraction of all rows.
  •  The number of rows includes those with N/A values.
Note: The result is a fractional value. For instance, a result of 20% would be represented as 0.20.
rank of # records The rank of each group, in terms of its number of records, with respect to all other groups.
  • The rank includes rows with N/A values.
number of unique values The number of unique values in the Column for each group.
  • If a group contains N/A values, those rows are ignored (i.e., the result is the number of unique non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.
sum The subtotal of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the sum of the non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.
% of grand total The subtotal of the Column for each group as a percentage of the grand total. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the sum of the non-N/A values in the group as a percentage of the sum of the non-N/A values in the entire column).
  • If a group contains only N/A values, the result for the group is 0.
Note: The result is a whole number, not a fractional value. For instance, a result of 20% would be represented as 20, not 0.20.
fraction of grand total The subtotal of the Column for each group as a fraction of the grand total. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the sum of the non-N/A values in the group as a fraction of the sum of the non-N/A values in the entire column).
  • If a group contains only N/A values, the result for the group is 0.
Note: The result is a fractional value. For instance, a result of 20% would be represented as 0.20.
rank of sum The rank of each group, in terms of its Column subtotal, with respect to the other groups. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the rank with respect to its subtotal of non-N/A values).
  • If a group contains only N/A values, the result is the rank with respect to a subtotal of 0.
average The average of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the average of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
rank of average The rank of each group, in terms of its Column average, with respect to the other groups. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the rank with respect to its average of non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
weighted average The average of the Column, weighted by the Reference Column, for each group. (numeric columns only)
  • If, for a particular group, either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result for the group is the weighted average for those rows where neither the Column nor the Reference Column is N/A).
  • If there are no such rows, the result for the group is N/A.
highest number The highest number in the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the highest non-N/A value).
  • If a group contains only N/A values, the result for the group is N/A.
lowest number The lowest number in the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the lowest non-N/A value).
  • If a group contains only N/A values, the result for the group is N/A.
first value The first value in the Column for each group. (alphanumeric and numeric columns) 

This is the first value based on the current sort order of the table (i.e., the way the data is shown when the table is viewed multiple rows at a time).

  • If a group contains N/A values, those rows are ignored (i.e., the result is the first of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
last value The last value in the Column for each group. (alphanumeric and numeric columns)

This is the last value based on the current sort order of the table (i.e., the way the data is shown when the table is viewed multiple rows at a time).

  • If a group contains N/A values, those rows are ignored (i.e., the result is the last of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
standard deviation The standard deviation of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the standard deviation of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
variance The variance of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the variance of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
weighted std dev The standard deviation of the Column, weighted by the Reference Column, for each group. (numeric columns only)
  • If, for a particular group, either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result for the group is the weighted standard deviation for those rows where neither the Column nor the Reference Column is N/A).
  • If there are no such rows, the result for the group is N/A.
weighted variance The variance of the Column, weighted by the Reference Column, for each group. (numeric columns only)
  • If, for a particular group, either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result for the group is the weighted variance for those rows where neither the Column nor the Reference Column is N/A).
  • If there are no such rows, the result for the group is N/A.
sum of squares The sum of squares of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the sum of squares of the non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.
correlation The correlation of the Column and the Reference Column, for each group. (numeric columns only)
  • If, for a particular group, either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result for the group is the correlation for those rows where neither the Column nor the Reference Column is N/A).
  • If there aren't at least two such rows in the group, the result is N/A.
covariance The covariance of the Column and the Reference Column, for each group. (numeric columns only)
  • If, for a particular group, either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result for the group is the covariance for those rows where neither the Column nor the Reference Column is N/A).
  • If there are no such rows, the result for the group is N/A.
dot product The dot product of the Column and the Reference Column, for each group. (numeric columns only)
  • If, for a particular group, either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result for the group is the dot product for those rows where neither the Column nor the Reference Column is N/A).
  • If there are no such rows, the result for the group is 0.
number of valid values The number of non-N/A values in the Column for each group.
number of N/As The number of N/A values in the Column for each group.
number of valid pairs The number of rows where both the Column and the Reference Column are not N/A, for each group.
number of N/A pairs The number of rows where either the Column or the Reference Column is N/A, for each group.
median The median of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the median of the non-N/A values).
  • If there are an even number of values, the median is the average of the two middle values.
  • If a group contains only N/A values, the result for the group is N/A.
mode The mode of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the mode of the non-N/A values).
  • If, for a given group, there is no unique mode, the result is arbitrary.
  • If a group contains only N/A values, the result for the group is N/A.
frequency of mode The frequency of the mode of the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the frequency of the mode of the non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.
number of modes The number of modes in the Column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the number of modes within the non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.