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

Latest revision as of 13:31, 2 February 2024

FUNCTIONS

Spreadsheet Lookup functions

Measures of dispersion / spread

Probability and statistics

Correlation and line fitting

See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND

Ranking

Returns the sample standard deviation of the arguments.

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:

.

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.

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.

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:STDEVA function}}
+{{Documentation/CalcFunc StatisticalTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_STDEV_function
+|NextPage=Documentation/How_Tos/Calc:_STDEVP_function
+}}__NOTOC__
 == STDEVA ==
@@ Line 26: / Line 31: @@
 : where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt> contain <tt>'''red'''</tt>, <tt>'''TRUE'''</tt>, and <tt>'''2'''</tt> returns <tt>'''1'''</tt>, the standard deviation of <tt>'''0'''</tt>, <tt>'''1'''</tt> and <tt>'''2'''</tt>.
-===Issues: ===
+===Issue: ===
 * Calc always evaluates text values as <tt>'''0'''</tt>. 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: <tt>'''STDEVA("red";1;2)'''</tt> returns Err:504 ([http://www.openoffice.org/issues/show_bug.cgi?id=87855 issue 87855], target OOo3.0).
+{{SeeAlso|EN|
-{{Documentation/SeeAlso|
 * [[Documentation/How_Tos/Calc: STDEV function|STDEV]]
 * [[Documentation/How_Tos/Calc: STDEVP function|STDEVP]]
@@ Line 41: / Line 44: @@
 * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
+[[Category: Documentation/Reference/Calc/Statistical functions]]