Excel Function : STDEVPA

Download now!

Excel Function : STDEVPA




Calculates standard deviation based on the entire population, including numbers, text, and logical values

Microsoft Excel Reference Page


Syntax and Description of the STDEVPA Excel Function

The syntax for the Excel STDEVPA function is as follows: STDEVPA( number1, [number2], ... ) The STDEVPA function takes one or more numbers as arguments and returns the population standard deviation for those numbers. More information The STDEVPA function measures the variability of a data set from the mean. The population standard deviation is calculated by taking the square root of the variance. The variance of a data set is calculated by taking the sum of the squared differences from the mean and then dividing by the number of values in the data set. The STDEVPA function takes as arguments one or more numeric values or ranges of numeric values. The function returns a

About STDEVPA Excel Function

The STDEVPA function calculates the standard deviation of a population based on a supplied set of values. The function uses the following syntax: STDEVPA(value1, [value2], ...) where value1, value2, etc. are the values for which you want to calculate the standard deviation.