writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + + Line 7:
Line 8: − + − + − + Line 25:
Line 26: − Line 39:
Line 39: − + + Line 45:
Line 46: − + + + + + Line 54:
Line 59: + + + + + + +
no edit summary
<div style="font-size:30px">'''STDEVPA(n1,n2,n3…)'''</div><br/>
<div style="font-size:30px">'''STDEVPA()'''</div><br/>
*<math>n1,n2,n3... </math> are numbers.
*Parameters are set of numbers.
**STDEVPA(),calculates standard deviation based on the entire population, including numbers, text, and logical values.
==Description==
==Description==
*It is the used as a measure of the dispersion or variation in a distribution.
*It is the used as a measure of the dispersion or variation in a distribution.
*It is calculated as the square root of variance.
*It is calculated as the square root of variance.
*In <math> STDEVPA(n1,n2,n3...)</math>, <math>n1,n2,n3...</math>, are numbers to find the standard deviation.
*In <math> STDEVPA()</math>, Parameters are set of numbers to find the standard deviation.
*Here <math> n1</math> is required. <math> n2,n3,...</math> are optional.
*Here First Parameter is required. From the second Parameter are optional.
*Instead of numbers we can use the single array or a reference of a array.
*Instead of numbers we can use the single array or a reference of a array.
*STDEVPA is defined by the formula:
*STDEVPA is defined by the formula:
<math>S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} </math>
<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 number in the given data.
where <math> \bar{x} </math> is the sample mean of <math> x </math> and <math> n </math> is the total number in the given data.
*It is calculated using <math> "n" </math> method.
*It is calculated using <math> n </math> method.
*This function is considering our given data is the entire population.
*This function is considering our given data is the entire population.
*Suppose it should consider the data as the sample of the population, we can use the [[Manuals/calci/STDEVA| STDEVA]] function.
*Suppose it should consider the data as the sample of the population, we can use the [[Manuals/calci/STDEVA| STDEVA]] function.
1. Any one of the argument is non-numeric.
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.
2. The arguments containing the error values or text that cannot be translated in to numbers.
==Examples==
==Examples==
| 2 || 2.4 || 3.7 ||14.9 || 28 || 198 || 154.1
| 2 || 2.4 || 3.7 ||14.9 || 28 || 198 || 154.1
|-
|-
| 5 || 9 || 17 || true || 6 || 0 || 41 || 14
!3
| 5 || 9 || 17 || true || 6 || 0 || 41
|}
|}
#=STDEVPA(A2:G2) = 76.31463871127
#=STDEVPA(A2:G2) = 76.31463871127
#=STDEVPA(A3:D3) = 5.916079783
#=STDEVPA(A3:D3) = 5.916079783
#=STDEVPA(2,12,22,32,false) = 11.180339887498949
#=STDEVPA(2,12,22,32,false) = 12.09297316626478
==Related Videos==
{{#ev:youtube|nQHG12zgl7I|280|center|STDEVP}}
==See Also==
==See Also==
==References==
==References==
*[http://en.wikipedia.org/wiki/Standard_deviation Standard Deviation]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]