STDEVP
Description
STDEVP returns the standard deviation based on the entire population of values. The standard deviation is a measure for the deviation from the average value (the mean).
Where:
|
SD |
= Standard deviation |
|
n |
= Number of elements for which the standard deviation is calculated. |
|
xi |
= Elements for which the standard deviation is calculated. |
Syntax
STDEVP ( number_list )
|
Parameter |
Description |
|
number_list |
A list of as many as 30 numbers, separated by commas. The list can contain numbers or a reference to a range that contains numbers. |
Example
This function returns .52:
STDEVP(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5)
Note:
If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.
Tip:
In analytical chemistry, usually only the STDEV function is relevant. This function calculates the standard deviation based on a random sample..
Also, see