STDEVP (Report Builder 1.0)
Returns the standard deviation of non-null values based on the entire population given as arguments.
Syntax
STDEVP(aggregate)
aggregate |
Specifies the field name or formula to aggregate. |
Remarks
The standard deviation is a measure of how widely values are dispersed from the average (the mean).
Text and logical values such as TRUE or FALSE are ignored.
STDEVP assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using STDEV.
For large sample sizes, STDEV and STDEVP return approximately equal values.
The standard deviation is calculated using the "biased" or "n" method.
Examples
Formula |
Result |
|---|---|
STDEVP(Sum Total Due) |
Returns the standard deviation for total sales due. The value returned is displayed similar to the following: 3843/-2671018501. |