Manuals/calci/STDEV

STDEV(n1,n2,n3…)

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

Description

• This function gives the Standard Deviation based on a given sample.
• 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.
• 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 STDEV(n1,n2,n3...)} , 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 n1,n2,n3...} , are numbers to find the Standard Deviation.
• Here 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 n1 } is required. 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 n2,n3,... } are optional.
• Instead of numbers, we can use the single array or a reference of a array.
• 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 $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

Spreadsheet

	A	B	C	D	E	F
1	0	4	6	10	12	15
2	7	3	-1	2	25
3	9	11	8	6	15

1. =STDEV(18,25,76,91,107) = 39.8660256358
2. =STDEV(208,428,511,634,116,589,907) = 267.0566196431
3. =STDEV(A1:F1) = 5.52871293039
4. =STDEV(A2:D2) = 3.304037933599
5. =STDEV(A3:B3) = 1.414213562373

See Also

• DSTDEV
• DSTDEVP
• STDEVP
• STDEVA