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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
 
(10 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:DEVSQ function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_TRIMMEAN_function
 +
|NextPage=Documentation/How_Tos/Calc:_KURT_function
 +
}}__NOTOC__
  
 
== DEVSQ ==
 
== DEVSQ ==
Line 8: Line 13:
 
: <tt>'''number1'''</tt> to <tt>'''number30'''</tt> are up to 30 numbers or ranges containing numbers.
 
: <tt>'''number1'''</tt> to <tt>'''number30'''</tt> are up to 30 numbers or ranges containing numbers.
  
−
: <tt>'''DEVSQ'''</tt> calculates the mean of all the numbers, then sums the squared deviation of each number from that mean. The formula is:
+
: <tt>'''DEVSQ'''</tt> calculates the mean of all the numbers, then sums the squared deviation of each number from that mean. With N values, the calculation formula is:
 
:: [[Image:Calc_devsq_equation.png]].
 
:: [[Image:Calc_devsq_equation.png]].
  
Line 16: Line 21:
 
: returns <tt>'''8'''</tt>, calculated as (-2)<sup>2</sup> + 0 + (2)<sup>2</sup>.
 
: returns <tt>'''8'''</tt>, calculated as (-2)<sup>2</sup> + 0 + (2)<sup>2</sup>.
  
−
=== See also: ===
+
{{SeeAlso|EN|
−
[[Documentation/How_Tos/Calc: VAR function|'''VAR''']],
+
* [[Documentation/How_Tos/Calc: VAR function|VAR]]
−
[[Documentation/How_Tos/Calc: STDEV function|'''STDEV''']],
+
* [[Documentation/How_Tos/Calc: STDEV function|STDEV]]
−
[[Documentation/How_Tos/Calc: AVERAGE function|'''AVERAGE''']]
+
* [[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]]
 +
* [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]]
  
−
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
 +
 
 +
* [[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:27, 2 February 2024



DEVSQ

Returns the sum of squares of deviations from the mean.

Syntax:

DEVSQ(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.
DEVSQ calculates the mean of all the numbers, then sums the squared deviation of each number from that mean. With N values, the calculation formula is:
Calc devsq equation.png.

Example:

DEVSQ(1; 3; 5)

returns 8, calculated as (-2)2 + 0 + (2)2.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_DEVSQ_function&oldid=260021"
Views
Personal tools
Navigation
Tools