wksStats Values

Value

Description

wksStatsFirstRow

calculate first row number containing data

wksStatsLastRow

calculate last row number containing data

wksStatsCount

calculate number of numeric cells

wksStatsMissing

calculate number of non-numeric cells, including blank cells

wksStatsSum

calculate sum of all numeric cells in the column

wksStatsMinimum

calculate minimum value in the column

wksStatsMaximum

calculate maximum value in the column

wksStatsRange

calculate range of numeric cells (difference between the maximum and minimum)

wksStatsMean

calculate arithmetic average of data values

wksStatsMedian

calculate middle data value

wksStatsFirstQuartile

calculate the first quartile value; 1/4 of the values are smaller than this number and 3/4 of the values are larger

wksStatsThirdQuartile

calculate the third quartile value; 3/4 of the values are smaller than this number and 1/4 of the values are larger

wksStatsStandardError

calculate standard deviation of the means

wksStatsConfidenceInterval95

calculate 95 percent confidence interval for the mean

wksStatsConfidenceInterval99

calculate 99 percent confidence interval for the mean

wksStatsVariance

calculate variance

wksStatsAverageDeviation

calculate average deviation

wksStatsStandardDeviation

calculate standard deviation - square root of the variance

wksStatsCoefficientOfVariation

calculate coefficient of variation

wksStatsSkewness

calculate coefficient of skewness

wksStatsKurtosis

calculate coefficient of kurtosis

wksStatsKSStatistic

calculate Kolmogorov-Smirnov goodness of fit statistic

wksStatsKSCriticalValue90

calculate critical value of Kolmogorov-Smirnov statistic at 90 percent confidence interval

wksStatsKSCriticalValue95

calculate critical value of Kolmogorov-Smirnov statistic at 95 percent confidence interval

wksStatsKSCriticalValue99

calculate critical value of Kolmogorov-Smirnov statistic at 99 percent confidence interval

wksStatsAll

calculate all of the above statistics