|
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% confidence interval for the mean |
|
wksStatsConfidenceInterval99 |
calculate 99% 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% confidence interval |
|
wksStatsKSCriticalValue95 |
calculate critical value of Kolmogorov-Smirnov statistic at 95% confidence interval |
|
wksStatsKSCriticalValue99 |
calculate critical value of Kolmogorov-Smirnov statistic at 99% confidence interval |
|
wksStatsAll |
calculate all of the above statistics |