Difference between revisions of "Manuals/calci/STDEVA"
Jump to navigation
Jump to search
(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=...") |
(No difference)
|
Revision as of 02:44, 25 October 2013
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 |
