Share via

  • Article

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.