Difference between revisions of "Manuals/calci/STDEVPIF"
Jump to navigation
Jump to search
(Created page with "stdevpif") |
|||
| Line 1: | Line 1: | ||
| − | + | <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 14:59, 26 April 2017
STDEVPIF (Array,Condition,SumArray)
- is the set of values.
- is the particular condition value.
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.
,