Manuals/calci/STDEVA

STDEVA(n1,n2,n3…)

• $n1,n2,n3...$ are numbers.

Description

• This function gives the Standard Deviation based on a given sample including the logical value and text.
• 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.
• In $STDEVA(n1,n2,n3...)$, $n1,n2,n3...$, are numbers to find the standard deviation. *Here $n1,$ is required. $n2,n3,..$ are optional.
• Instead of numbers we can use the single array or a reference of a array.
• $STDEVA$ is defined by the formula:

$S.D={\sqrt {\frac {\sum (x-{\bar {x}})^{2}}{(n-1)}}}$ where ${\bar {x}}$ is the sample mean of x and n is the total numbers in 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 consider our given data as the sample population.
• Suppose it consider the data as the entire population, we can use the STDEVPA function.
• The arguments can be be either numbers or names, array,constants or references that contain numbers.
• Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a reference.
• Suppose the arguments containing TRUE which is evaluate as 1, and the arguments containing FALSE which is evaluate as 0.
• Suppose the array contains the empty cells and text values like that values are not considered.
• Suppose the function don't want to consider the logical values and text representations of numbers in a reference, we can use the STDEV 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

Spreadsheet

	A	B	C	D	E	F	G
1	208	428	511	634	116	589	907
2	18	25	76	91	107

1. =STDEVA(A2:E2) = 39.8660256358
2. =STDEVA(A1:G1) = 267.0566196431
3. =STDEVA(4,8,TRUE) = 3.51188458428
4. =STDEVA(12,18,27,32,false) = 12.617448236470002

Related Videos

STANDARD DEVIATION

See Also

• DSTDEV
• DSTDEVP
• STDEVP
• STDEV

References

• Standard Deviation