The Value tab
The Value tab displays various summary statistics for the selected column. Those statistics are only available for columns with numeric values.
- Count: Number of values in the column
- Distinct: Number of different values in the column
- Duplicate: Number of identical values in the column
- Valid: Number of valid values in the column
- Empty: Number of empty records in the column
- Invalid: Number of invalid values in the column
- Avg length: Average length of the string values based on the number of characters in the column records
- Min length: Minimum length of the string values based on the number of characters in the column records
- Max length: Maximum length of the string values based on the number of characters in the column records
- Min: The lowest value of the column
- Max: The highest value of the column
- Mean: The average value of the column
- Variance: The distribution of the values compared to the mean value. Mathematically defined as the average of the squared differences from the mean value.