From ZCubes Wiki
Jump to navigation Jump to search

  • Parameters are set of numbers.
    • STDEVP(),calculates standard deviation based on the entire population


  • This function gives the standard deviation based on a entire population as the the given data .
  • Standard Deviation is a quantity expressing by how much the members of a group differ from the mean value for the group.
  • It is the used as a measure of the dispersion or variation in a distribution.
  • It is calculated as the square root of variance.
  • In , Parameters are set of numbers to find the Standard Deviation.
  • Here First Parameter is required. From the second parameter are optional.
  • Instead of numbers we can use the single array or a reference of a array.
  • is defined by the formula:

where is the sample mean of x and n is the total numbers in the given data.

  • It is calculated using method.
  • This function is considering our given data as the entire population.
  • Suppose it should consider the data as the sample of the population, we can use the STDEV function.
  • For huge sample sizes the functions and are approximately equal values.
  • The arguments can be either numbers or names, array,constants or references that contain numbers.
  • Suppose the array contains text,logical values or empty cells, like that values are not considered.
  • When we are entering logical values and text representations of numbers as directly, then the arguments are counted.
  • Suppose the function have to consider the logical values and text representations of numbers in a reference , we can use the STDEVPA function.
  • This function will return the result as error when
   1. Any one of the argument is non-numeric. 
   2. The arguments containing the error values or text that cannot be translated in to numbers.


1 87 121 427 390 110 54 32
2 2 2.4 3.7 14.9 28 198 154.1
3 9 -4 -29 38 101 19 45
  1. =STDEVP(A1:E1) = 149.0597195757
  2. =STDEVP(A2:G2) = 76.31463871127
  3. =STDEVP(A3:E3) = 44.58250778015
  4. =STDEVP(0,2,8,10,11.7,23.8,32.1,43.7) = 14.389530699435

Related Videos


See Also