Difference between revisions of "Documentation/How Tos/Calc: STDEVPA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
(→Issues:) |
||
| Line 38: | Line 38: | ||
* 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. | * 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>'''STDEVPA("red";1;2)'''</tt> returns Err:504 ([http://www.openoffice.org/issues/show_bug.cgi?id=87855 issue 87855] | + | * Text given as a parameter fails: <tt>'''STDEVPA("red";1;2)'''</tt> returns Err:504 ([http://www.openoffice.org/issues/show_bug.cgi?id=87855 issue 87855], target OOo3.0). |
| − | + | ||
| − | + | ||
Revision as of 10:51, 10 April 2008
STDEVPA
Returns the population standard deviation (allowing text and logical values).
Syntax:
STDEVPA(number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges containing numbers. Logical values and text may also be included.
- STDEVPA returns the standard deviation where number1 to number30 are the entire population. If you only have a sample of the population use STDEVA instead.
- Logical values are regarded as 1 (TRUE) and 0 (FALSE).
- Text values are always regarded as zero.
- For a population of N values, the calculation formula is:
-
.
Example:
STDEVPA(3; 3; 7; 7)
- returns 2.
STDEVPA(B1:B4)
- where cells B1, B2, B3, B4 contain red, FALSE, 4, 4 returns 2, the population standard deviation of 0, 0, 4 and 4.
See also:
STDEVP, STDEV, STDEVA, VARP, VARPA
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: STDEVPA("red";1;2) returns Err:504 (issue 87855, target OOo3.0).
