STDEVP

Using the Excel STDEVP Function

Summary

The Excel STDEVP function calculates the standard deviation based on the entire population, ignoring logical values and text. Standard deviation is a measure of how widely values are dispersed from the mean. The mean can be found using the AVERAGE function.

The STDEVP function has been replaced by the STDEV.P function that provides improved accuracy. Microsoft recommends that people use STDEV.P.


Syntax

=STDEVP (number1, [number2], ...)

Syntax Breakdown

Number 1
Required. The first number that corresponds to a population. An array or reference to an array can also be used.

Number 2
Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments. An array or reference to an array can also be used.


Usage Notes

STDEVP returns the standard deviation from data that is representative of an entire population, ignoring logical and text values. To calculate the standard deviation for a sample, use the STDEV.S function.

Standard deviation is used to calculate the variance in a set of numbers compared to the average, or mean, of the numbers. STDEVP is intended to estimate the standard deviation for an entire population.

Standard deviation is calculated using the "n" method.

Logical values and text representations of numbers that are entered directly into an argument are counted. The function ignores logical values, text representation of numbers, error values, and empty cells that are contained in an array or reference.

Use the STDEVA function to calculate logical values and text representation of numbers.

Variations of Standard Deviation Functions in Excel
Function Data Set Text & Logical Values
STDEV Sample Ignored
STDEVP Population Ignored
STDEV.S Sample Ignored
STDEV.P Population Ignored
STDEVA Sample Evaluated
STDEVPA Population Evaluated