You can generate detailed statistics on numeric and date fields in a table. Statistics are frequently used to get an overview of a table before detailed analysis takes place. You can highlight abnormalities in the data, which you can use to guide your subsequent analysis.

The results of generating statistics are described in Table 1.

Statistic |
Number |
Total |
Average |
---|---|---|---|

Range |
This is the total range of values from lowest to highest |
||

Positive |
The number of positive values |
The total of all positive values |
The average positive value |

Negative |
The number of negative values |
The total of all negative values |
The average negative value |

Zeros |
The number of zero values |
||

Totals |
The total number of positive, negative, and zero values |
The total of all positive, negative, and zero values |
The average of all positive, negative, and zero values |

Abs Value |
The total of all values while disregarding the sign of the numbers |
||

Std. Dev. (optional) |
The standard deviation from the mean value |

Generating statistics also displays the five highest and five lowest field values. If you want to see more or fewer high and low values, you can change the # of High/Low parameter on the More tab.