Range-The range of values (maximum minus minimum) for the specified field will be calculated.Maximum-The largest value for all records of the specified field will be found.Minimum-The smallest value for all records of the specified field will be found.Mean-The average for the specified field will be calculated.Sum-The values for the specified field will be added together.Numeric attribute fields can be summarized using any statistic.Īvailable statistics types are as follows: Text attribute fields can be summarized using first and last statistics. Null values are excluded from all calculations. Multiple statistic and field combinations can be specified.

Specifies the numeric field or fields containing the attribute values that will be used to calculate the specified statistic. When using layers, only the currently selected features will be used to calculate statistics. For example, the average of 10, 5, and a null value is 7.5 ((10+5)/2). Null values are excluded from all statistical calculations. The Output Table parameter value will contain only one record if no Case Field parameter value is specified.

If the Case Field parameter value is specified, statistics will be calculated separately for each unique attribute value, and there will be one record for each unique Case Field value. The field name is truncated to 10 characters when the output table is a dBASE table. The following statistical operations are available with this tool: sum, mean, minimum, maximum, range, standard deviation, count, first, last, median, variance, and unique.Ī field will be created for each statistic type using the following naming convention: SUM_, MEAN_, MIN_, MAX_, RANGE_, STD_, COUNT_, FIRST_, LAST_, MEDIAN_, VARIANCE_, UNIQUE_, and CONCATENATE_ in which is the name of the input field for which the statistic is computed. The Output Table value will consist of fields containing the result of the statistical operation.

Statistical tools for data analysis