2.13.1.24 wstats

Menu Information

Statistics: Descriptive Statistics: Statistics On Whole Sheet

Calculate descriptive statistics on whole sheet

wstats -r 2 quantities:="n|mean|sd|sum|min|median|max|lcl|ucl|var" identifier:="Name|Range";

Display Name	Variable Name	I/O and Type	Default Value	Description
	iw	Input Worksheet	<active>	The active worksheet to perform statistics on
Quantities	quantities	Input string	mean\|sd\|sum\|min\|median\|max	Specifies which quantity to be computed and output. n : N total missing: N missing mean: Mean sd: Standard deviation sem: SE of Mean lcl: Lower 95% CI of Mean ucl: Upper 95% CI of Mean var: Variance sum: Sum skewness: Skewness kurtosis: Kurtosis uss: Uncorrected Sum of Squares css: Corrected Sum of Squares cv: Coefficient of Variance mad: Mean absolute Deviation sdx2: SD times 2 sdx3: SD times 3 geomean: Geometric Mean geosd: Geometric SD mode: Mode harmmean: Harmonic Mean min: Minimum imin: Index of Minimum q1: 1st Quartile (Q1) median: Median q3: 3rd Quartile (Q3) max: Maximum imax: Index of Maximum iqr: Interquartile Range (Q3-Q1) range: Range (Maximum-Minimum) cp: Custom Percentile(s) medad: Median Absolute Deviation rcv: Robust Coefficient of Variation
Percentile list	perc	Input string	90 95 99	Percentile value
Dataset Identifier	identifier	Input string	Name	Specify the identifier Name Range Book Name Sheet Name Sheet Display Name Short Name Long Name Units Comments
Output	rd	Output ReportData	[<input>]<new>	Specifies the output worksheet.

Perform statistics on the whole worksheet. There is also a tool named as Statistic on Whole Sheet, which can be accessed from the main menu.

Keywords:mean, median, standard deviation, sum