Xceed Grid for WinForms v4.3 Documentation
StatFunction Enumeration


Xceed.Grid.v4.3 Assembly > Xceed.Grid Namespace : StatFunction Enumeration
Value representing the statistical function used by a SummaryCell to calculate its value.
Syntax
'Declaration
 
Public Enum StatFunction 
   Inherits System.Enum
'Usage
 
Dim instance As StatFunction
public enum StatFunction : System.Enum 
Members
MemberDescription
AverageThe measure of central tendancy of a set of values computed by dividing the sum of the values by their number; commonly called the arithmetic mean or the average.
CountThe result of a tally that reveals the number of items in a set.
GeometricMean

The geometric mean of a set of positive data is defined as the product of all the members of the set, raised to a power equal to the reciprocal of the number of members.

The geometric mean can only be calculated on elements whose values are greater than 0. If the set contains an element whose value is less than or equal to 0, then GridControl.OverflowErrorText will be displayed.

HarmonicMean

The number of elements to be averaged divided by the sum of the reciprocals of the elements.

The harmonic mean can only be calculated on elements whose values are greater than 0. If the set contains an element whose value is less than or equal to 0, then GridControl.OverflowErrorText will be displayed.

Maximum

The value of the item with the highest value among a set of items.

If a object that implements the System.IComparable interface is assigned to the Column.DataComparer property of the column represented by SummaryCell.StatFieldName, it will be used to calculate the maximum value.

MedianThe middle number in a set of ordered data. If the set contains an even number of items, the arithmetic mean of the 2 middle values will be returned.
Minimum

The value of the item with the lowest value among a set of items.

If a object that implements the System.IComparable interface is assigned to the Column.DataComparer property of the column represented by SummaryCell.StatFieldName, it will be used to calculate the minimum value.

Mode

The value that has the largest number of observations, namely the most frequent value or values. The mode is not necessarily unique, unlike the arithmetic mean.

The mode can be calculated for any type of data. In the case of a multimodal set of values, only one of the mode will be returned. Ex. : [1, 2, 2, 6, 6] is bimodal (2 and 6) and the function will return either 2 or 6.

Nothing will be returned if all the items in the set are unique.

NoneNo statistical function is used.
RootMeanSquareThe square root of the arithmetical average of a set of squared instantaneous values. The root mean square is also known as the quadratic mean.
StandardDeviationA measure of the degree of dispersion of sample data from the mean value.
StandardDeviationPopulationA measure of the degree of dispersion of population data from the mean value.
SumThe result of the addition of the values of a set of items.
VarianceThe variance of a random sample variable is a non-negative number which gives an idea of how widely spread the values of the random variable are likely to be; the larger the variance, the more scattered the observations on average.
VariancePopulationThe variance of a random population variable is a non-negative number which gives an idea of how widely spread the values of the random variable are likely to be; the larger the variance, the more scattered the observations on average.
Remarks

If the SummaryCell's SummaryCell.StatFunction property is set to StatFunction.None, the cell will, by default, not be visible. a null reference (Nothing in Visual Basic) and dbNull value are not considered in the statistical functions.

In statistics, a statistical population is a set of entities concerning which statistical inferences are to be drawn, often based on a random sample taken from the population. For example, if we were interested in generalizations about crows, then we would describe the set of crows that is of interest. Notice that if we choose a population like all crows, we will be limited to observing crows that exist now or will exist in the future. Probably, geography will also constitute a limitation in that our resources for studying crows are also limited.

"Population" is also used to refer to a set of measurements or values. Suppose, for example, we are interested in the set of all adult crows now alive in the county of Kent, and we want to know the mean weight of these birds. For each bird in the population of crows there is a weight, and the set of these weights is called the "population of weights".

A sample is that part of a population which is actually observed. In normal scientific practice, we demand that it be selected in such a way as to avoid presenting a biased view of the population. If statistical inference is to be used, there must be a way of assigning known probabilities of selection to each sample. If the probabilities of different samples are all equal, for example, the method is called simple random sampling.

Information taken from Wikipedia

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Xceed.Grid.StatFunction

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

Xceed.Grid Namespace