Manuals/calci/STDEVP

STDEVP(n1,n2,n3…)

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

Description

• This function gives the standard deviation based on a entire population as the the given data .
• 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 $STDEVP(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.
• $STDEVP$ 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 (syntax error): {\displaystyle "n" } method.
• This function is considering our given data as the entire population.
• Suppose it should consider the data as the sample of the population, we can use the STDEV function.
• For huge sample sizes the functions $STDEV$ and $STDEVP$ are approximately equal values.
• The arguments can 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 STDEVPA 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	87	121	427	390	110	54	32
2	2	2.4	3.7	14.9	28	198	154.1
3	9	-4	-29	38	101	19	45

1. =STDEVP(A1:E1) = 149.0597195757
2. =STDEVP(A2:G2) = 76.31463871127
3. =STDEVP(A3:E3) = 44.58250778015
4. =STDEVP(0,2,8,10,11.7,23.8,32.1,43.7) = 14.389530699435

See Also

• DSTDEV
• DSTDEVP
• STDEV
• STDEVA

References

• Standard Deviation