Statistics

Statistics displays statistics on the current table column. To use this command you must go to Table View and select a column which has a numeric value.

Click on Table > Column > Statistics button.

Confirm if you would like to search the whole table for existing values:

To stop seeing this message, check the Scan all rows without prompting tickbox.

Depending on the data the following statistics will be shown in the Table Column Statistics dialog:

  • Rows (Number of Rows)
  • Sum (Sum of all values)
  • Minimum value
  • Maximum value
  • Range (difference between minimum and maximum)
  • Mean (average value)
  • Median (the number separating the higher half of the values from the lower half)
  • Variance (average of the squared distance of values from the mean).
  • Standard Deviation
  • Number of unique values
  • Lowest value count
  • Highest value count
  • Unique values (list of the values)

Also depending on the data the following chart types will be available:

  • Line chart
  • Area chart
  • Pie chart
  • Bar chart (vertical)
  • Bar chart (horizontal)

Example:

This AnimalRescue.swd example shows the locations and dates of animal rescue incidents, rehoming requests and a dangerous dog report:

Click Table (View > Document Views)

The columns are Date, Description, Animal and Day.

Select the Date column in the Table View and click the Statistics button.

A message will be displayed asking if you want to search the whole table for existing values.

Click Yes to continue, No will stop the command at this point.

The Table Column Statistics dialog will be displayed:

The display will open at the Pie chart setting, this can be changed in the Type drop-down box so that the data is shown as a Line chart, Area chart, Pie chartBar chart (vertical) or Bar chart (horizontal).

The Clipboard button drop-down gives the following options:

Copy chart - Copies the chart as displayed in the Table Column Statistics dialog to the clipboard. This can then be pasted into an image editor or pasted into an editing application, i.e. Microsoft Word:

Copy Statistics - Copies the statistics as shown in the Table Column Statistics dialog, top left pane, to the clipboard.

In this example; Rows, Number of unique values, Lowest value count, Highest value count. These statistics can then be pasted into a spreadsheet application, i.e. Microsoft Excel:

Copy data - Copies the data as shown in the Table Column Statistics dialog, top left pane, to the clipboard. The data shown depends on the table column selected when the Statistics command was started, in this example it is the range of dates. This data can then be pasted into a spreadsheet application, i.e. Microsoft Excel: