Manuals/calci/STDEVPIF

Revision as of 13:59, 26 April 2017 by Devika (talk | contribs)
STDEVPIF (Array,Condition,SumArray)


  • is the set of values.
  • is the particular condition value.

Description

  • This function gives the standard deviation based on a entire population as the the given data which satisfies the given condition.
  • In  ,  is the set of values.
  •   is the particular condition which satisfies the Standard deviation value.
  • 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.