Difference between revisions of "Manuals/calci/STDEVPIF"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "stdevpif")
 
Line 1: Line 1:
stdevpif
+
<div style="font-size:30px">'''STDEVPIF (Array,Condition,SumArray)'''</div><br/>
 +
*<math>Array</math> is the set of values.
 +
*<math>Condition</math> 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 <math>STDEVPIF (Array,Condition,SumArray)</math>,<math>Array</math> is the set of values.
 +
*<math>Condition</math> 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.

Revision as of 13:59, 26 April 2017

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.