Attribute statistics in Freq

This section explains various attribute statistics available in the Freq component.

Basic attribute statistics

Basic attribute statistics are calculated for numerical attributes only. They are available via the Statistics display mode of an attribute in the Freq component.

Attribte value set statistics

Freq calculates the following statistics to provide a rough overview of the distribution of attribute values:

Minimum value.  This is the smallest value attained by the attribute

Maximum value.  This is the largest value attained by the attribute

1st quartile.  This is a number which splits the samples into two parts: samples with values below the 1st quartile constitute 1/4 of of the dataset, samples with values above the 1st quartile constitute 3/4 of the dataset.

Median value.  This is a number which splits the samples into two equal parts: samples with values below and above the median constitute respectively 1/2 of the value set. Median value is also called 2nd quartile.

3rd quartile.  This is a number which splits the samples into two parts: samples with values below the 3rd quartile constitute 3/4 of of the dataset, samples with values above the 3rd quartile constitute 1/4 of the dataset.

Note

The minimum and maximum value statistics are different from Min and Max values in Intervals mode settings for an attribute.

Attribute moments

For a numerical attribute let denote the number of samples and the value of the -th sample.

Mean value

The mean value (1st moment) of an attribute is calculated as

Variance

The variance (2nd moment) of an attribute is calculated as

Variance measures how far the values of an attribute are spread out from the mean.

Standard Deviation

The standard deviationf an attribute is calculated as

Skewness

The skewness (3rd standardized moment) of an attribute is calculated as

Positive skewness indicates that the bulk of the samples lie mostly to the right of the mean, negative skewness means that there are more samples to the left of the mean.

Kurtosis

The excess curtosis of an attribute is the ratio of the fourth moment about the mean by the square of the variance minus 3. It is calculated as

Positive values of excess kurtosis indicate that the density of the attribute has a thin and high peak near the mean and its tails are fatter. Negative values of excess curtosis indicate that the density peak around the mean is lower and broader, and the tails are thinner. Normal distributions have excess kurtosis equal to 0.

Attribute correlation statistics

Attribute correlation statistics are available in the Correlation matrix component.

Pearson's correlation coefficient

Pearson's correlation coefficient calculated for two numerical attributes is a popular measure of attribute interdepence. It assumes values between -1 and 1, the value of 1 corresponds to perfect positive linear dependence between attributes, while the value of -1 corresponds to negative linear dependece.

Let denote the sample size, , the values of the -th sample. Pearson's correlation coefficient is calculated as

Correlation ratio

Correlation ratio is a measure of dependece between a categorical variable and a numerical variable , defined as the ratio of two standard deviations representing respectively the statistical dispersion of within individual categories of and the dispersion of across the whole sample.

Assume that the variable is divided into categories and for each category the variable attains the values (here is the number of samples in the category ). Let be the total sample count.

For a given category define

as the average of restricted to the category .

The weighted standard deviation of category means is defined as

The correlation ratio between and is calculated as

In the calculation of correlation ratio matrix, if is a numerical attribute attaining at most 100 distinct values, it will be treated as categorical, with each value corresponding to one category. If the number of different values exceeds 100, the correlation ratios with as the categorical variable will not be calculated.

Figure 24.24. Correlation ratio matrix for the cloud dataset

Correlation ratio matrix for the cloud dataset

The correlation ratio matrix in the figure above has been calculated with rows treated as categorical variables. The numerical attribute period attains more than 100 values, hence the corresponding row does not contain any values.

Select Row is categorical or Column is categorical from the context menu to choose whether the variables corresoponding respectively to rows or columns are treated as categorical in the calculation of the correlation ratio statistics.

Cramer's V-correlation

There are three statistics associated with Cramer's V-correlation: the Chi-Square coefficident, Crammer's coefficient and P-value.

Chi-Square coefficient

The Chi-Square statistic can be treated as a measure of independence of two categorical variables and .

Assume that is divided into categories with counts and is divided into categories with counts , denotes the number of observations for which the value of belongs to and the value of belongs to . Let be the total sample size.

The theoretical frequency for a given pair of categories is calculated as

The value of the Chi-Square statistic is then calculated as

Cramer's coefficient

For two categorical variables the Cramer's coefficient assumes values between 0 and 1. The value of corresponds to no association between variables and to complete association.

The coefficient is calculated accoriding to the formula

P-value

The P-value is equal to the probability of obtaining a Chi-Square statistic equal to or greater than the calculated value of assuming that and are independent.

Target related statistics

For an attribute let be the number of levels and be the index of the level.

Weight of Evidence

The BeingGood value for the level of the attribute is calculated according to the formula

where

  • is the number of records in the dataset for which the value of the attribute belongs to the -th level and is not the positive target value.
  • is the number of records in the dataset for which the value of the attribute belongs to the -th level and is the positive target value.
  • is the total number of records in the training dataset for which the value of the attribute is not the positive target value.
  • is the total number of records in the training dataset for which the value of the attribute is the positive target value.

The Weight of Evidence statistic for the -th level of the attribute is calculated as

Information Value

The Information Value statistics for the attribute is calculated as