Types of Summarizations for Quick Summaries

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

number of unique values The number of unique values in the Column.
  • If the column contains N/A values, those values are ignored (i.e., the result is the number of unique non-N/A values).
  • If the column contains only N/A values, the result is 0.
sum The total for the Column. (numeric columns only)
  • If the column contains N/A values, those values are ignored (i.e., the result is the sum of the non-N/A values).
  • If the column contains only N/A values, the result is 0.
average The average of the Column(numeric columns only)
  • If the column contains N/A values, those values are ignored (i.e., the result is the average of the non-N/A values).
  • If the column contains only N/A values, the result is N/A.
weighted average The average of the Column weighted by the Reference Column. (numeric columns only)
  • If either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result 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 is N/A.
highest number The highest number in the Column. (numeric columns only)
  • If the column contains N/A values, those values are ignored (i.e., the result is the highest non-N/A value).
  • If the column contains only N/A values, the result is N/A.
lowest number The lowest number in the Column. (numeric columns only)
  • If the column contains N/A values, those values are ignored (i.e., the result is the lowest of the non-N/A values).
  • If the column contains only N/A values, the result is N/A.
standard deviation The standard deviation of the Column. (numeric columns only)
  • If the column contains N/A values, those values are ignored (i.e., the result is the standard deviation of the non-N/A values).
  • If the column contains only N/A values, the result is N/A.
variance The variance of the Column. (numeric columns only)
  • If the column contains N/A values, those values are ignored (i.e., the result is the variance of the non-N/A values).
  • If the column contains only N/A values, the result is N/A.
weighted std dev The standard deviation of the Column weighted by the Reference Column. (numeric columns only)
  • If either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result 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 is N/A.
weighted variance The variance of the Column weighted by the Reference Column. (numeric columns only)
  • If either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result 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 is N/A.
sum of squares The sum of squares for the Column. (numeric columns only)
  • If the column contains N/A values, those values are ignored (i.e., the result is the sum of squares of the non-N/A values).
  • If the column contains only N/A values, the result is 0.
correlation The correlation of the Column with the Reference Column. (numeric columns only)
  • If either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result 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, the result is N/A.
covariance The covariance of the Column and the Reference Column. (numeric columns only)
  • If either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result 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 is N/A.
dot product The dot product of the Column and the Reference Column. (numeric columns only)
  • If either the Column or the Reference Column contains N/A values, those rows are ignored (i.e., the result 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 is 0.
number of valid values The number of non-N/A values in the Column.
number of N/As The number of N/A values in the Column.
number of valid pairs The number of rows where both the Column and the Reference Column are not N/A.
number of N/A pairs The number of rows where either the Column or the Reference Column is N/A.