StdDev

The StdDev function returns a standard deviation based on a sample. It is a measure of how widely values are dispersed from the average value (the mean).

StdDev (numbers, break_col)

where:

numbers references the column that contains the numbers on which the standard deviation is calculated.

break_col is an optional parameter that references a break column.

Note:

StdDev assumes that its arguments are a sample of the population. If you data represents the entire population, then compute the standard deviation using StdDevp.

Note:

The standard deviation is calculated using the nonbiased or n-1 method.

Note:

If a result set contains one row of data or less, the StdDev function should return an error.

The following examples show the results of inserting the StdDev function in two separate tables.

Example

In this example, the StdDev function is used on the numeric column. The results are shown in the Computed column.

StdDev (Amount)