Using the Excel STDEV.P Function
SummaryThe 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.
Syntax=STDEV.P (number1, [number2], ...)
Syntax BreakdownNumber 1
Required. The first number that corresponds to a population. An array or reference to an array can also be used.
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 NotesSTDEV.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|