Excel STDEVP Function
Excel STDEVP function returns standard deviation of the entire population, ignoring the text and logical values in cell references.
=STDEVP (number1, [number2], ...)
The syntax has the following arguments:
number1 (required argument) – First number of population data
[number2], … (optional arguments) – Additional arguments of population data
Excel STDEVP function has been replaced with Excel STDEV.P function, which is available in Excel 2010 and later versions. Excel STDEVP function is still available as compatibility with Excel 2007 and earlier versions. You can add 255 arguments in function and arguments can be added as numbers, names, arrays or cell references.
Arguments may contain numbers, text values, logical values, and empty cells, but Excel STDEVP function evaluates only numbers, ignoring the text, logical values and empty cells in cell references. However, logical values and text representations of numbers entered directly as an argument are evaluated in Excel STDEVP function to calculate the standard deviation of population data.
For example, you have a data set of subject scores of the entire population in cell references A2:A12 that may contain text and logical values. You want to return standard deviation by ignoring the text and logical values. You need to use Excel STDEVP function in following formula to calculate the standard deviation of population data set.
Figure 1. STDEVP_Function
Consider the following point before using Excel STDEVP function:
- It assumes that data provided in arguments represent population data. If data is the sample of a population then use Excel STDEV.S function or STDEV function.
- It calculates standard deviation using the “n” method.
- It ignores to evaluate text and logical values in population data. If you want to evaluate these values then use Excel STDEVPA function.
- Text representations of numbers directly entered as an argument in Excel STDEVP function are counted as numbers.
- Text representations of numbers entered as values in cell references are considered as text values and are ignored by Excel STDEVP function.
- If text value is directly entered as an argument, Excel STDEVP function returns #VALUE! error.