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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
Line 26: Line 26:
 
* [[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]]
+
[[Category: Documentation/Reference/Calc/Statistical functions]]

Revision as of 11:49, 17 May 2010


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.

Template:Documentation/SeeAlso

Personal tools