2.13.1.24 wstats


Menu Information

Statistics: Descriptive Statistics: Statistics On Whole Sheet

Brief Information

Calculate descriptive statistics on whole sheet

Command Line Usage

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

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

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.

Description

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.

Related X-Functions

moments, quantiles, rowstats, Colstats



Keywords:mean, median, standard deviation, sum