Calculating Margins for a Table

You can calculate and add margins to a spreadsheet table using various summary statistics.

From the menu select Spread | Calculate | Table Margins.
Select the statistic to use for forming the margins then click OK.

Form margins using

Note: the summary statistic is formed based on the information within the cells and does not take account of any weights or the number of observations used in calculating the values.

Totals – Creates the margins using the total of the values in the table.
Mean – Creates the margins using the mean of the values in the table.
Minima – Creates the margins using the minimum of the values in the table.
Maxima – Creates the margins using the maximum of the values in the table.
Medians – Creates the margins using the median of the values in the table.
Variances – Creates the margins using the variance of the values in the table.

Create table in new spreadsheet

The table will be duplicated in a new spreadsheet with a new name. If this option has not been selected the margin will be added to the table in the current spreadsheet.

Add new sheet to current book

This option only appears when the Create table in new spreadsheet option has been selected. When a new spreadsheet is created this option can be used to add the new sheet to the current book.

Updated on December 14, 2018

Was this article helpful?

Yes No