In this article, we will learn about how to use STDEVPA function in Excel to calculate the standard deviation for the range of values.
STDEVPA function is a built-in function to calculate the standard deviation of the range of population data provided. The standard deviation for the set of values is calculated using the formula shown below.
There are newer and updated versions of this function used for a different set of values.
Logica values : TRUE is considered as 1 whereas FALSE as 0.
Text : text values are considered as 0.
STDEVPA function in excel returns a number which is the standard deviation, considering population data having text or logical values.
Syntax of STDEVPA function:
|=STDEVPA ( Value 1, [value 2], ...)|
value 1 : First value ( necessary )
value 2 : Second value ( optional ). Upto 255 values can be added.
Let’s understand this function using an example.
Here we have a range of values from B1 : B20 cell and we need to get the standard deviation for the same using the below formula.
Use the formula
|=STDEVPA ( B1 : B20 )|
Here array argument to the function is given using the cell reference method.
Using the above formula in the cell to get the standard deviation of the values.
The Standard deviation for the range considering text values and Logic values is 25.94 whereas STDEV function returns 21.19 . This difference occurs as the value of n in the formula changes, as in STDEVPA case value of n is 20 ( includes text & logic values ) but for STDEV case value of n is 17 ( ignores text & Logic values ).
As you can see the STDEVPA function in excel returns values from the table field.
Hope you understood How to use the STDEV function in Excel. Explore more articles on Mathematical functions like STDEV and STDEV.P functions here. Please state your query or feedback in the comment box below.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.