Difference between revisions of "Documentation/How Tos/Calc: STDEVA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
(→Example:: example with text, logical values) |
||
| Line 18: | Line 18: | ||
<tt>'''STDEVA(2; 6; 4)'''</tt> | <tt>'''STDEVA(2; 6; 4)'''</tt> | ||
: returns <tt>'''2'''</tt>. | : returns <tt>'''2'''</tt>. | ||
| + | |||
| + | <tt>'''STDEVA(B1:B3)'''</tt> | ||
| + | : 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>. | ||
=== See also: === | === See also: === | ||
Revision as of 06:59, 4 April 2008
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.
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.
See also:
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.
