# 17.1.3.1 The Statistics on Whole Sheet Dialog Box

## 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 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$. $s=\sqrt{\sum_{i=1}^n w_i(x_i-\bar{x})^2/d}$ where $d=n-1 \,$ $\sum_{i=1}^n x_iw_i$. If there is no WEIGHT variable, the formula reduces to $\sum_{i=1}^n x_i$. $x_{(1)}\,$ Median or second (50%) quantile, Q2. See Interpolation of quantiles for Statistics on Columns dialog box for computational methods $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. Use the workbook long name. Use the worksheet name. Use the long name of the corresponding column if there is a long name, otherwise use the short name of column. Use the short name of the corresponding column. Use the long name of the corresponding column.

## Output

Specify where to output the report worksheet