Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).

The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

STDEV.P takes 1 required argument and 253 optional arguments:

Syntax: STDEV.P(number1, [number2], ... )

#1)
The arguments for the STDEV.P function are:
Argument Required? Description
number1 Required The first number argument corresponding to a population.
number2, ... Optional Number arguments 2 to 254 corresponding to a population. You can also use a single array or a reference to an array instead of arguments separated by commas.
comments powered by Disqus