Using the Excel STDEV.P Function


The Excel STDEV.P 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.

STDEV.P replaces the STDEVP function, which is still available for backwards compatibility purposes. Microsoft recommends using the STDEV.P function.

Use the STDEV.S function to find the standard deviation based on a sample.


=STDEV.P (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

STDEV.P 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 STDEV.S.

Standard deviation is used to calculate the variance in a set of numbers compared to the average, or mean, of the numbers. STDEV.P 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