Stats

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Stats

Description

Calculates the sum, minimum, maximum, average, median or standard deviation of numeric values by column or row in one or more selected columns.

 

Inputs

One.

 

Options

Check the column(s) you wish to calculate stats for.

Set Calculation to the statistic you want to calculate.

Set On depending on whether you wish to calculate the statistics for columns, rows or both.

oIf On is set to Columns an extra row with the results is added to the bottom.

oIf On is set to Rows an extra column with the results is added to the right.        

oIf On is set to Columns and rows  an extra row with the results is added to the bottom and extra column with the results is added to the right.        The bottom right cell contains the calculation across all values.

 

Notes

The average is the arithmetic mean.

The standard deviation is the sample standard deviation (equivalent to Excel function stddev.s).

Non-numerical and empty values are ignored.

Use Num Format to change the precision of the results.

 

See also

Count

Pivot

Summary