Table window

Statistics pane

The statistics pane lists for each value column in a table:

the minimum,
the maximum,
the average,
the standard deviation, and
the sum of the values in the column.

The statistics pane is a split window which can either be shown or hidden. If it is shown it will always be shown at the bottom of the table window; you cannot drag the statistics pane to another position on your screen. If you like, you can change the height of the statistics pane. The order of the statistical values is fixed and the values themselves cannot be edited.

Figure 1 below shows part of the Rainfall table. In the upper part of the picture, there is the table view pane showing the names of the rainfall stations (domain of table) and the rainfall values for the months March and April (columns). The statistics pane is shown in the lower part of the picture.

Fig. 1: Statistics pane at the bottom of a table window.

To hide or show the statistics pane:

Choose Statistics Pane from the View menu of the table window.

The statistics pane is shown when a check mark appears in front of the menu command.

Upon closing a table, it is stored whether or not the statistics pane is shown in the current table. This will then be used as the default setting to show or hide the statistics pane when the table is re-opened later on.

To change the height of the statistics pane:

Position the mouse pointer at the split bar between the table view pane and the statistics pane as indicated in Figure 1.
Drag the split bar up or down to increase or to decrease the height of the statistics pane.

To recalculate column statistics:

When you have dependent columns, and when input data has changed, the values in the dependent columns may still reflect the situation of the 'old' input data. The statistics pane will then also show 'old' values.

Recalculate all columns:

choose Update All Columns from the Columns menu in the table window, or
click the Update All Columns button in the toolbar.

The values in the statistics pane are automatically recalculated.

To copy statistics to clipboard:

To copy the statistical values for all columns to clipboard, copy the records in the statistics pane to clipboard.

Select the records you wish to copy:

To select a single record: click the record button of the record you wish to copy.
To select multiple records in sequence:

keep the left mouse button down while moving over the record buttons of the records that you wish to copy,

click the first record button of a sequence of records that you wish to copy,
press the Shift key on the keyboard and hold it down,
click the last record button of a sequence or records that you wish to copy.

Copy the selection to clipboard:

choose Copy from the Edit menu,
click the Copy button in the toolbar,
press the Ctrl+C keys on the keyboard, or
click the selection with the right mouse button, and choose Copy from the context-sensitive menu.

For more information, see Table window : Copy to clipboard.

Tip:

To calculate other column statistics, such as Standard error, Variance, Covariance, Correlation, Student's t-test or a -test, choose Column Statistics from the Columns menu of a table window.