Spread 8.0 Documentation
STDEVP
Support Options
Formula Reference > Built-In Functions > STDEVP

Glossary Item Box

STDEVP


Name

Standard deviation for population

Description

Calculates standard deviation based on the entire population given as arguments.

Syntax

STDEVP(value1, value2, . . . )

Remarks

The standard deviation is a measure of how widely values are dispersed from the average value.

Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.

The standard deviation is calculated using the "biased" or "n" method. The function uses the following formula to calculate the standard deviation:

The STDEVP function assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using the STDEV function.

See also AVERAGE, STDEV, VAR, and VARP.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

STDEVP(R1C2,R3C4,R4C5,R7C2)
STDEVP(A1,B2,C3,D4,E5,F6)
STDEVP(A1:A9)
STDEVP(95,89,73,87,85,76,100,96,96)=8.8079649700

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.