Difference between revisions of "Documentation/How Tos/Calc: STDEVA function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
Line 1: Line 1:
−
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
 +
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_STDEVP_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_STDEV_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Text_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of Central Tendency</div>
 +
* [[Documentation/How_Tos/Calc:_AVEDEV_function|<div style="font-size: 120%;">Avedev]]
 +
* [[Documentation/How_Tos/Calc:_AVERAGE_function|<div style="font-size: 120%;">Average]]
 +
* [[Documentation/How_Tos/Calc:_AVERAGEA_function|<div style="font-size: 120%;">Averagea]]
 +
* [[Documentation/How_Tos/Calc:_COUNT_function|<div style="font-size: 120%;">Count]]
 +
* [[Documentation/How_Tos/Calc:_COUNTA_function|<div style="font-size: 120%;">Counta]]
 +
* [[Documentation/How_Tos/Calc:_GEOMEAN_function|<div style="font-size: 120%;">Geomean]]
 +
* [[Documentation/How_Tos/Calc:_HARMEAN_function|<div style="font-size: 120%;">Hearmean]]
 +
* [[Documentation/How_Tos/Calc:_MEDIAN_function|<div style="font-size: 120%;">Median]]
 +
* [[Documentation/How_Tos/Calc:_MODE_function|<div style="font-size: 120%;">Mode]]
 +
* [[Documentation/How_Tos/Calc:_TRIMMEAN_function|<div style="font-size: 120%;">Trimmean]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of dispersion / spread</div>
 +
* [[Documentation/How_Tos/Calc:_DEVSQ_function|<div style="font-size: 120%;">Devsq]]
 +
* [[Documentation/How_Tos/Calc:_KURT_function|<div style="font-size: 120%;">Kurt]]
 +
* [[Documentation/How_Tos/Calc:_SKEW_function|<div style="font-size: 120%;">Skew]]
 +
* [[Documentation/How_Tos/Calc:_STDEV_function|<div style="font-size: 120%;">Stdev]]
 +
* [[Documentation/How_Tos/Calc:_STDEVA_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Stedeva]]
 +
* [[Documentation/How_Tos/Calc:_STDEVP_function|<div style="font-size: 120%;">Stdevp]]
 +
* [[Documentation/How_Tos/Calc:_STDEVPA_function|<div style="font-size: 120%;">Stdevpa]]
 +
* [[Documentation/How_Tos/Calc:_VAR_function|<div style="font-size: 120%;">Var]]
 +
* [[Documentation/How_Tos/Calc:_VARA_function|<div style="font-size: 120%;">Vara]]
 +
* [[Documentation/How_Tos/Calc:_VARP_function|<div style="font-size: 120%;">Varp]]
 +
* [[Documentation/How_Tos/Calc:_VARPA_function|<div style="font-size: 120%;">Varpa]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Probability and statistics</div>
 +
* [[Documentation/How_Tos/Calc:_B_function|<div style="font-size: 120%;">B]]
 +
* [[Documentation/How_Tos/Calc:_BETADIST_function|<div style="font-size: 120%;">Betadist]]
 +
* [[Documentation/How_Tos/Calc:_BETAINV_function|<div style="font-size: 120%;">Betainv]]
 +
* [[Documentation/How_Tos/Calc:_BINOMDIST_function|<div style="font-size: 120%;">Binomdist]]
 +
* [[Documentation/How_Tos/Calc:_CHIDIST_function|<div style="font-size: 120%;">Chidist]]
 +
* [[Documentation/How_Tos/Calc:_CHIINV_function|<div style="font-size: 120%;">Chinv]]
 +
* [[Documentation/How_Tos/Calc:_CHISQINV_function|<div style="font-size: 120%;">Chisqinv]]
 +
* [[Documentation/How_Tos/Calc:_CHITEST_function|<div style="font-size: 120%;">Chitest]]
 +
* [[Documentation/How_Tos/Calc:_CONFIDENCE_function|<div style="font-size: 120%;">Confidence]]
 +
* [[Documentation/How_Tos/Calc:_CRITBINOM_function|<div style="font-size: 120%;">Critbinom]]
 +
* [[Documentation/How_Tos/Calc:_EXPONDIST_function|<div style="font-size: 120%;">Expondist]]
 +
* [[Documentation/How_Tos/Calc:_FINV_function|<div style="font-size: 120%;">Finv]]
 +
* [[Documentation/How_Tos/Calc:_FISHER_function|<div style="font-size: 120%;">Fisher]]
 +
* [[Documentation/How_Tos/Calc:_FISHERINV_function|<div style="font-size: 120%;">Fisherinv]]
 +
* [[Documentation/How_Tos/Calc:_FDIST_function|<div style="font-size: 120%;">Fdist]]
 +
* [[Documentation/How_Tos/Calc:_FTEST_function|<div style="font-size: 120%;">Ftest]]
 +
* [[Documentation/How_Tos/Calc:_GAMMA_function|<div style="font-size: 120%;">Gamma]]
 +
* [[Documentation/How_Tos/Calc:_GAMMAINV_function|<div style="font-size: 120%;">Gammainv]]
 +
* [[Documentation/How_Tos/Calc:_GAMMALN_function|<div style="font-size: 120%;">Gammaln]]
 +
* [[Documentation/How_Tos/Calc:_GAMMADIST_function|<div style="font-size: 120%;">Gammadist]]
 +
* [[Documentation/How_Tos/Calc:_GAUSS_function|<div style="font-size: 120%;">Gauss]]
 +
* [[Documentation/How_Tos/Calc:_HYPGEOMDIST_function|<div style="font-size: 120%;">Hypgeomdist]]
 +
* [[Documentation/How_Tos/Calc:_LOGINV_function|<div style="font-size: 120%;">Loginv]]
 +
* [[Documentation/How_Tos/Calc:_LOGNORMDIST_function|<div style="font-size: 120%;">Lognormdist]]
 +
* [[Documentation/How_Tos/Calc:_NEGBINOMDIST_function|<div style="font-size: 120%;">Negbinomdist]]
 +
* [[Documentation/How_Tos/Calc:_NORMINV_function|<div style="font-size: 120%;">Norminv]]
 +
* [[Documentation/How_Tos/Calc:_NORMDIST_function|<div style="font-size: 120%;">Normdist]]
 +
* [[Documentation/How_Tos/Calc:_NORMSINV_function|<div style="font-size: 120%;">Normsinv]]
 +
* [[Documentation/How_Tos/Calc:_NORMSDIST_function|<div style="font-size: 120%;">Normsdist]]
 +
* [[Documentation/How_Tos/Calc:_PERMUT_function|<div style="font-size: 120%;">Permut]]
 +
* [[Documentation/How_Tos/Calc:_PERMUTATIONA_function|<div style="font-size: 120%;">Permutationa]]
 +
* [[Documentation/How_Tos/Calc:_PHI_function|<div style="font-size: 120%;">Phi]]
 +
* [[Documentation/How_Tos/Calc:_POISSON_function|<div style="font-size: 120%;">Poisson]]
 +
* [[Documentation/How_Tos/Calc:_PROB_function|<div style="font-size: 120%;">Prob]]
 +
* [[Documentation/How_Tos/Calc:_STANDARDIZE_function|<div style="font-size: 120%;">Standardize]]
 +
* [[Documentation/How_Tos/Calc:_TDIST_function|<div style="font-size: 120%;">Tdist]]
 +
* [[Documentation/How_Tos/Calc:_TINV_function|<div style="font-size: 120%;">Tinv]]
 +
* [[Documentation/How_Tos/Calc:_TTEST_function|<div style="font-size: 120%;">Ttest]]
 +
* [[Documentation/How_Tos/Calc:_WEIBULL_function|<div style="font-size: 120%;">Weibull]]
 +
* [[Documentation/How_Tos/Calc:_ZTEST_function|<div style="font-size: 120%;">Ztest]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Correlation and line fitting</div>
 +
* [[Documentation/How_Tos/Calc:_CORREL_function|<div style="font-size: 120%;">Correl]]
 +
* [[Documentation/How_Tos/Calc:_COVAR_function|<div style="font-size: 120%;">Covar]]
 +
* [[Documentation/How_Tos/Calc:_FORECAST_function|<div style="font-size: 120%;">Forecast]]
 +
* [[Documentation/How_Tos/Calc:_INTERCEPT_function|<div style="font-size: 120%;">Intercept]]
 +
* [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]]
 +
* [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%;">Rsq]]
 +
* [[Documentation/How_Tos/Calc:_SLOPE_function|<div style="font-size: 120%;">Slope]]
 +
* [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]]
 +
<div style="font-size: 110%;">''See also (in the [[Documentation/How_Tos/Calc:_Array_functions|Array Function]] category); GROWTH, LINEST, LOGEST, TREND''</div>
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Ranking</div>
 +
* [[Documentation/How_Tos/Calc:_LARGE_function|<div style="font-size: 120%;">Large]]
 +
* [[Documentation/How_Tos/Calc:_MAX_function|<div style="font-size: 120%;">Max]]
 +
* [[Documentation/How_Tos/Calc:_MAXA_function|<div style="font-size: 120%;">Maxa]]
 +
* [[Documentation/How_Tos/Calc:_MIN_function|<div style="font-size: 120%;">Min]]
 +
* [[Documentation/How_Tos/Calc:_MINA_function|<div style="font-size: 120%;">Mina]]
 +
* [[Documentation/How_Tos/Calc:_PERCENTILE_function|<div style="font-size: 120%;">Percentile]]
 +
* [[Documentation/How_Tos/Calc:_PERCENTRANK_function|<div style="font-size: 120%;">Percentrank]]
 +
* [[Documentation/How_Tos/Calc:_QUARTILE_function|<div style="font-size: 120%;">Quartile]]
 +
* [[Documentation/How_Tos/Calc:_RANK_function|<div style="font-size: 120%;">Rank]]
 +
* [[Documentation/How_Tos/Calc:_SMALL_function|<div style="font-size: 120%;">Small]]
 +
}}__TOC__
  
 
== STDEVA ==
 
== STDEVA ==

Revision as of 22:47, 1 June 2013


STDEVA

Returns the sample standard deviation of the arguments.

Syntax:

STDEVA(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers. Logical values and text may also be included.
STDEVA returns the standard deviation where number1 to number30 are a sample of the entire population.
Logical values are regarded as 1 (TRUE) and 0 (FALSE).
Text values are always regarded as zero.
With N values in the sample, the calculation formula is:
Calc sample stddev formula.png.

Example:

STDEVA(2; 6; 4)

returns 2.

STDEVA(B1:B3)

where cells B1, B2, B3 contain red, TRUE, and 2 returns 1, the standard deviation of 0, 1 and 2.

Issues:

  • Calc always evaluates text values as 0. The forthcoming international standard ODFF optionally allows numerical text to be converted to number form. Portability between ODFF compliant spreadsheets may therefore be an issue.
  • Text given as a parameter fails: STDEVA("red";1;2) returns Err:504 (issue 87855, target OOo3.0).
Template:Documentation/SeeAlso
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_STDEVA_function&oldid=225872"
Views
Personal tools
Navigation
Tools