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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
 
(8 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:STDEVPA function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_STDEVP_function
 +
|NextPage=Documentation/How_Tos/Calc:_VAR_function
 +
}}__NOTOC__  
  
 
== STDEVPA ==
 
== STDEVPA ==
Line 9: Line 14:
 
: <tt>'''number1'''</tt> to <tt>'''number30'''</tt> are up to 30 numbers or ranges containing numbers. Logical values and text may also be included.
 
: <tt>'''number1'''</tt> to <tt>'''number30'''</tt> are up to 30 numbers or ranges containing numbers. Logical values and text may also be included.
  
−
: <tt>'''STDEVPA'''</tt> returns the standard deviation where <tt>'''number1'''</tt> to <tt>'''number30'''</tt> are the entire population. If you only have a sample of the population use <tt>'''STDEVA'''</tt> instead.
+
: <tt>'''STDEVPA'''</tt> returns the standard deviation where <tt>'''number1'''</tt> to <tt>'''number30'''</tt> are the entire population. If you only have a sample of the population, use <tt>'''STDEVA'''</tt> instead.
  
 
: Logical values are regarded as <tt>'''1'''</tt> (<tt>'''TRUE'''</tt>) and <tt>'''0'''</tt> (<tt>'''FALSE'''</tt>).
 
: Logical values are regarded as <tt>'''1'''</tt> (<tt>'''TRUE'''</tt>) and <tt>'''0'''</tt> (<tt>'''FALSE'''</tt>).
Line 26: Line 31:
 
: where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt>, <tt>'''B4'''</tt> contain <tt>'''red'''</tt>, <tt>'''FALSE'''</tt>, <tt>'''4'''</tt>, <tt>'''4'''</tt> returns <tt>'''2'''</tt>, the population standard deviation of <tt>'''0'''</tt>, <tt>'''0'''</tt>, <tt>'''4'''</tt> and <tt>'''4'''</tt>.
 
: where cells <tt>'''B1'''</tt>, <tt>'''B2'''</tt>, <tt>'''B3'''</tt>, <tt>'''B4'''</tt> contain <tt>'''red'''</tt>, <tt>'''FALSE'''</tt>, <tt>'''4'''</tt>, <tt>'''4'''</tt> returns <tt>'''2'''</tt>, the population standard deviation of <tt>'''0'''</tt>, <tt>'''0'''</tt>, <tt>'''4'''</tt> and <tt>'''4'''</tt>.
  
−
{{Documentation/SeeAlso|
+
===Issue: ===
−
* [[Documentation/How_Tos/Calc: STDEVP function|STDEVP]],
+
* 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.
−
* [[Documentation/How_Tos/Calc: STDEV function|STDEV]],
+
 
−
* [[Documentation/How_Tos/Calc: STDEVA function|STDEVA]],
+
{{SeeAlso|EN|
−
* [[Documentation/How_Tos/Calc: VARP function|VARP]],
+
* [[Documentation/How_Tos/Calc: STDEVP function|STDEVP]]
 +
* [[Documentation/How_Tos/Calc: STDEV function|STDEV]]
 +
* [[Documentation/How_Tos/Calc: STDEVA function|STDEVA]]
 +
* [[Documentation/How_Tos/Calc: VARP function|VARP]]
 
* [[Documentation/How_Tos/Calc: VARPA function|VARPA]]
 
* [[Documentation/How_Tos/Calc: VARPA function|VARPA]]
  
Line 37: Line 45:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
−
 
+
[[Category: Documentation/Reference/Calc/Statistical functions]]
−
===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>'''STDEVPA("red";1;2)'''</tt> returns Err:504 ([http://www.openoffice.org/issues/show_bug.cgi?id=87855 issue 87855], target OOo3.0).
+

Latest revision as of 13:32, 2 February 2024



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:
Calc pop stddev formula.png.

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.

Issue:

  • 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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_STDEVPA_function&oldid=260027"
Views
Personal tools
Navigation
Tools