writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 12:
Line 12: − + Line 24:
Line 24: − <div id="6SpaceContent" class="zcontent" align="left"> − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''STDEV'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V1'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,V2,...)</font></font></font>+ − + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Where V1,V2,......are arguments.</font></font></font>+ − + − </div>+ − ----+ − <div id="1SpaceContent" class="zcontent" align="left"> + − + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">It calculates the Standard deviation for a set of values.</font></font></font>+ − + − </div>+ − ----+ − <div id="7SpaceContent" class="zcontent" align="left"> + − + − * <font color="#484848"><font face="Arial, sans-serif"><font size="2">S D is calculated by the "n-1" method.</font></font></font>+ − * <font color="#484848"><font face="Arial, sans-serif"><font size="2">The Arguments can be numbers or names, arrays, or references. </font></font></font> − * <font color="#484848"><font face="Arial, sans-serif"><font size="2">Empty cells, logical values, text, or error values are ignored. </font></font></font> − * <font color="#484848"><font face="Arial, sans-serif"><font size="2">S D formula is: </font></font></font>+ − *+ + + + − <font color="#484848"></font>+ + + + + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Where x is the sample mean average (V1,V2........) and n is the sample size.</font></font></font> − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − STDEV − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">150</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">130</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">165</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">132</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">110</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">137</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">121</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">UNIQ69bde0a373272bec-nowiki-00000002-QINU</font></font></font> − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | class=" " | Column1 − | class=" " | Column2 − | class=" " | Column3 − | class=" " | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f " | 150 − | class="sshl_f" | 18.184242 − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | class=" " | Row2 − | class="sshl_f " | 130 − | class="SelectTD" | − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | Row3 − | class="sshl_f " | 165 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | Row4 − | class="sshl_f " | 132 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class=" " | Row5 − | class="sshl_f " | 110 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | class="sshl_f" | Row6 − | class="sshl_f " | 137 − | class="sshl_f " | − | class="sshl_f " | − | class="sshl_f" | − |- class="odd" − | class="sshl_f" | Row7 − | class="sshl_f " | 121 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |} − <div align="left">[[Image:calci1.gif]]</div></div>+ − ---- − <div id="9SpaceContent" class="zcontent" align="left"><div>[[Image:13.JPG|100%px|http://store.zcubes.com/33975CA25A304262905E768B19753F5D/Uploaded/13.JPG]]</div></div> − ----
no edit summary
*Here <math> n1 </math> is required. <math> n2,n3,... </math> are optional.
*Here <math> n1 </math> is required. <math> n2,n3,... </math> 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.
*<math> STDEV </math> is defined by the formula: <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 numbers in the given data.
*<math> STDEV </math> is defined by the formula: <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 numbers in the given data.
*It is calculated using <math>"n-1" </math> method.
*It is calculated using <math>"n-1" </math> method.
*This function is considering our given data is the sample of the population.
*This function is considering our given data is the sample of the population.
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==
{| class="wikitable"
|+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
|}
# STDEV(18,25,76,91,107)=39.8660256358
#STDEV(208,428,511,634,116,589,907)=267.0566196431
#STDEV(A1:F1)=5.52871293039
#STDEV(A2:D2)=3.304037933599
#STDEV(A3:B3)=1.414213562373
==See Also==
*[[Manuals/calci/DSTDEV | DSTDEV]]
*[[Manuals/calci/DSTDEVP | DSTDEVP ]]
*[[Manuals/calci/STDEVP | STDEVP ]]
*[[Manuals/calci/STDEVA| STDEVA]]
==References==