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";
Please refer to the page for additional option switches when accessing the x-function from script
Input
Worksheet
string
Output
ReportData
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.
moments, quantiles, rowstats, Colstats
Keywords:mean, median, standard deviation, sum