Manuals/calci/STDEVP

From ZCubes Wiki
Revision as of 21:45, 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">'''STDEVP'''</font></font></font><font color="#...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

STDEVP(N1,N2,...)

Where N1,N2, ... are the arguments .

 

This function calculates the standard deviation on the entire population.

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


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

STDEVP

Lets see an example,

150

130

165

132

110

137

121

=STDEVPA(B2:B8)is 16.84

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