Calculations can be performed on the table data using built-in aggregate functions, tally, group, and crosstab. The number of duplicate values with a column can also be determined. From the "Calculate option on the Data Browser menu bar, the following options are available:
•Compute... - computes statistical data such as Count, Rows, Minimum, Maximum, Sum, Average, Standard Deviation and Variance for a column's values
•Tally... - tallies the number of occurrences for each unique column value
•Group... - groups each unique column value and displays each
•Crosstab... - creates a crosstab output of the columns from the table that you configure
•Aggregate... - displays the Count, Rows, Minimum, Maximum, Sum, Average, Standard Deviation or Variance of the column values in the column header
•Duplicates... - calculates the number of duplicate occurrences for the column
Function |
Description |
Average |
Computes the numeric average of CURRENCY, DOUBLE, NUMERIC, REAL, INTEGER, DATE, or TIME data types. R:BASE rounds averages of integer values to the nearest integer value and currency values to their nearest unit. |
Count |
Determines how many non-null entries there are for a particular column item. |
Maximum |
Selects the maximum value in a column. This option accepts columns with any data type except BIT, VARBIT, VARCHAR, and BITNOTE. * |
Minimum |
Selects the minimum value in a column. This option accepts columns with any data type except BIT, VARBIT, VARCHAR, and BITNOTE. * |
Standard Deviation |
Computes standard deviation for CURRENCY, DOUBLE, REAL, NUMERIC, or INTEGER data types. The standard deviation is a measure of how widely values are dispersed from the average value. |
Sum |
Computes the numeric sum of CURRENCY, DOUBLE, REAL, NUMERIC, or INTEGER data types. |
Variance |
Determines variance for CURRENCY, DECIMAL, DOUBLE, REAL, NUMERIC, or INTEGER data types. |