Difference between revisions of "Documentation/How Tos/Calc: VARA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 27: | Line 27: | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
| − | * [[Documentation/How_Tos/Calc: VAR function|VAR]] | + | * [[Documentation/How_Tos/Calc: VAR function|VAR]] |
| − | * [[Documentation/How_Tos/Calc: VARP function|VARP]] | + | * [[Documentation/How_Tos/Calc: VARP function|VARP]] |
| − | * [[Documentation/How_Tos/Calc: VARPA function|VARPA]] | + | * [[Documentation/How_Tos/Calc: VARPA function|VARPA]] |
* [[Documentation/How_Tos/Calc: STDEV function|STDEV]] | * [[Documentation/How_Tos/Calc: STDEV function|STDEV]] | ||
Revision as of 14:45, 26 February 2009
VARA
Returns the sample variance (allowing text and logical values).
Syntax:
VARA(number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges containing numbers. Logical values and text may also be included.
- VARA 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:
-
.
Example:
VARA(2; 6; 4)
- returns 4.
VARA(B1:B3)
- where cells B1, B2, B3 contain red, TRUE, and 2 returns 1, the variance of 0, 1 and 2.
Template:Documentation/SeeAlso
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: VARA("red";1;2) returns Err:504 (issue 87855, target OOo3.0).
