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

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎See also:)
m
 
(9 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:VARA function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_VAR_function
 +
|NextPage=Documentation/How_Tos/Calc:_VARP_function
 +
}}__NOTOC__
  
 
== VARA ==
 
== VARA ==
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 variance of <tt>'''0'''</tt>, <tt>'''1'''</tt> and <tt>'''2'''</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 variance of <tt>'''0'''</tt>, <tt>'''1'''</tt> and <tt>'''2'''</tt>.
  
−
=== See also: ===
+
===Issues: ===
−
[[Documentation/How_Tos/Calc: VAR function|'''VAR''']],
+
* Calc always evaluates text values as <tt>'''0'''</tt>. The international standard ODFF optionally allows numerical text to be converted to number form. Portability between ODFF compliant spreadsheets may therefore be an issue.
−
[[Documentation/How_Tos/Calc: VARP function|'''VARP''']],
+
−
[[Documentation/How_Tos/Calc: VARPA function|'''VARPA''']],
+
−
[[Documentation/How_Tos/Calc: STDEV function|'''STDEV''']]
+
  
−
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: VAR function|VAR]]
 +
* [[Documentation/How_Tos/Calc: VARP function|VARP]]
 +
* [[Documentation/How_Tos/Calc: VARPA function|VARPA]]
 +
* [[Documentation/How_Tos/Calc: STDEV function|STDEV]]
  
−
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
−
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+
−
 
+
−
===Issues: ===
+
−
* 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>'''VARA("red";1;2)'''</tt> returns Err:504 ([http://www.openoffice.org/issues/show_bug.cgi?id=87855 issue 87855], target OOo3.0).
+
* [[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]]

Latest revision as of 13:35, 2 February 2024



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:
Calc sample var formula.png.

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.

Issues:

  • Calc always evaluates text values as 0. The 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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_VARA_function&oldid=260029"
Views
Personal tools
Navigation
Tools