The StdDevp function calculates and returns a standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
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.
StdDevp assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using StdDev. |
The following examples show the results of inserting the StdDevp function in two separate tables.
In this example, the StdDevp function is used for the numeric column. The results are shown in the Computed column.
StdDevp (Amount)