Manuals/calci/STDEV

From ZCubes Wiki
Revision as of 20:44, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''STDEV'''</font></font></font><font color="#4...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

STDEV(V1,V2,...)

Where V1,V2,......are arguments.

 

It calculates the Standard deviation for a set of values.

 
  • S D is calculated by the "n-1" method.
  • The Arguments can be numbers or names, arrays, or references.
  • Empty cells, logical values, text, or error values are ignored.
  • S D formula is:

Where x is the sample mean average (V1,V2........) and n is the sample size.

STDEV

 

150

130

165

132

110

137

121

=STDEV(B2:B8) is 18.18

Syntax
Remarks
Examples
Description
Column1 Column2 Column3 Column4
Row1 150 18.184242
Row2 130
Row3 165
Row4 132
Row5 110
Row6 137
Row7 121
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/STDEV&oldid=603"