The SDL Component Suite is an industry leading collection of components supporting scientific and engineering computing. Please visit the SDL Web site for more information.... 
Home MathPack DataTable Methods MeanVarOfNumCells  
See also: QuartilesOfNumCells, MinMaxOfNumCells, GeometricMeanOfNumCells, HarmonicMeanOfNumCells, MeanVarOfMarkedCells  
MeanVarOfNumCells 

The method MeanVarOfNumCells calculates the mean and the variance of all matrix elements within a specified range of cells which are neither marked as csNAN, nor as csUndefined and which belong to either interval or ratio scaled variables (that is "real" numbers). The range of matrix elements to be used is determined by the parameters LowRow, LowCol, HighRow, and HighCol. If any of these parameters receives an invalid value, this value is automatically adjusted to the nearest boundary value (either 1 or NrOfColumns / NrOfRows). The variable parameters Mean and Variance return the mean and the variance of the selected data. The function returns the number of data points used for the calculation (i.e. the number of numeric data cells within the specified range).
