Manuals/calci/STDEVIF

STDEVIF (Array,Condition,SumArray)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the set of values.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Condition} is the particular condition value.

Description

• This function shows the Standard Deviation of the given set which satisfies the given condition.
• In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle STDEVIF (Array,Condition,SumArray)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the set of values.
• $Condition$ 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.

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle STDEV } is defined by the formula:

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} }

where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar{x} } is the sample mean of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n } is the total numbers of the given data.

• It is calculated using Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle (n-1)} 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 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 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

Examples

1. STDEVIF([19,17,23,10,12,15,22],">10") = 4.1952353926806065
2. STDEVIF([22,24,27,32,10,18,45,43,55,14],"<15") = 2.8284271247461903
3. STDEVIF([22,24,27,32,10,18,45,43,55,14],">15") = 13.046619704516788

Related Videos

Standard Deviation IF

See Also

• STDEV
• STDEVP
• STDEVA

References

• Standard Deviation

• List of Main Z Functions
• Z3 home