DEVSQ function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 13:27, 2 February 2024 by DiGro (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



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