writer
6,694
edits
Changes
no edit summary
STDEVIF
<div style="font-size:30px">'''STDEVIF (Array,Condition,SumArray)'''</div><br/>
*<math>Array</math> is the set of values.
*<math>Condition</math> is the particular condition value.
==Description==
*This function shows the Standard Deviation of the given set which satisfies the given condition.
*In <math>STDEVIF (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 the quantity expressed by, how many members of a group differ from the mean value of 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.
<math> STDEV </math> is defined by the formula:
<math>S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} </math>
where <math> \bar{x} </math> is the sample mean of <math> x </math> and <math> n </math> is the total numbers of the given data.
*It is calculated using <math>"n-1"</math> method.
*This function is considering our given data is the sample of the population.
*Suppose it should consider the data as the entire population, we can use the [[Manuals/calci/STDEVP | STDEVP ]] function.
*The arguments can be 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 [[Manuals/calci/STDEVA| STDEVA]] 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