Summarization Formulas

The following standard summarization formulas are available for use in the 'Summary' field of the data binding.

Table 12. Summarization Formulas

Formula

Description

Sum

Calculating the sum total of numbers.

Average

Calculating the average (mean) of numbers.

Count

Count the number of elements.

Max

Find the largest number.

Min

Find the smallest number.

Distinct Count

Count the number of distinct elements.

Product

Calculate the product (multiplication) of numbers.

Standard Deviation

Calculate the standard deviation of the number series.

Variance

Variance is a measure of dispersion. The mean of the square of the deviations is called the variance

Population Variance

This is the average of squared differences between the mean and each item in the population.

Population Standard Deviation

Standard deviation is a measure of dispersion. It is the positive square root of the variance. See also variance.

Correlation

The correlation coefficient indicates the degree of linear relationship between two variables. The correlation coefficient always lies between -1 and +1. -1 indicates a perfect negative linear relationship between two variables, +1 indicates a perfect positive linear relationship, and 0 indicates a lack of any linear relationship.

Covariance

The covariance between two random variables X and Y is the expected value of the product of the variables' deviations from their means. If there is a high probability that large values of X go with large values of Y and small values of X go with small values of Y, then the covariance between X and Y will be positive; if there is a high probability that small values of X go with large values of Y and large values of X go with small values of Y, then the covariance will be negative.

Weighted Average

A weighted average is a modified version of an arithmetic mean. An average of 5 and 7 is 12/2=6, but you can count 5 twice so that a weighted average is 17/3=5.67, etc.

Median

Calculates the value that is in the middle of a list. The median of a population is the point that divides the distribution of scores in half.

pth Percentile

The pth percentile of a data set is defined as that value where p percent of the data is below that value and (1-p) percent of the data is above that value. For example, the 50th percentile is the median.

nth Largest

Returns the nth largest number in a list.

nth Smallest

Returns the nth smallest number in a list.

Mode

Returns the value that occurs most frequently.

nth Most Frequent

Returns the nth most frequent value in a list.

Concat

Concatenates values into a comma-separated list.

<< 6.2.5 Grouping and Summarization in Data Binding Wizard © 1996-2013 InetSoft Technology Corporation (v11.5) Walkthrough: Grouping and Summary in Data Binding Wizard >>