17.1.4.1 The Statistics on Whole Sheet Dialog Box

1 Recalculate
2 Input Worksheet
3 Quantities
4 Dataset Identifier
5 Output

Recalculate

See Recalculating Analysis Results for details of the recalculation options.

Input Worksheet

Specify the input worksheet. See here of details of how to specify input data range.

Quantities

Specify the quantities to be calculated for each column, respectively. $x_i\,$ is the $i\,$ th sample.

N Total	Total number of data points, denoted by n
Mean	The mean (average) score $\bar{x}=\frac 1w\sum_{i=1}^n x_iw_i$ . If there is no WEIGHT variable, the formula reduces to $\frac 1n\sum_{i=1}^n x_i$ .
Standard Deviation	$s=\sqrt{\sum_{i=1}^n w_i(x_i-\bar{x})^2/d}$ where $d=n-1 \,$
Sum	$\sum_{i=1}^n x_iw_i$ . If there is no WEIGHT variable, the formula reduces to $\sum_{i=1}^n x_i$ .
Minimum	$x_{(1)}\,$
Median	Median or second (50%) quantile, Q2. See Interpolation of quantiles for Statistics on Columns dialog box for computational methods
Maximum	$x_{(n)}\,$

Percentile list displays the percentile values fixed as "90 95 99".

Dataset Identifier

Multiple identifier(s) can be inserted into the output summary table to show the source datasets information. You can add, remove, order identifiers via controlling buttons: Move Up button , Move Down button , Remove button , Select All button , Select button in toolbar .

Each type of identifiers will be add as a column in the summary worksheet. Options are:

Range	Use the range syntax.
Book Name	Use the workbook long name.
Sheet Name	Use the worksheet name.
Name	Use the long name of the corresponding column if there is a long name, otherwise use the short name of column.
Short Name	Use the short name of the corresponding column.
Long Name	Use the long name of the corresponding column.

Output

Specify where to output the report worksheet