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 >> |