Manuals/calci/STDEVA

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">'''STDEVA'''</font></font></font><font color=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  

STDEVA (v1, v2...)

Where v1,v2.....are arguments.

 

In standard deviation the values are dispersed from the mean.

 
  • 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.

STDEVA

 

150

130

165

132

110

137

121

=STDEVA(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/STDEVA&oldid=604"