DEVSQ

The DEVSQ function returns the sum of the squares of deviations of a set of numbers from their average (arithmetic mean).

DEVSQ(num-value, num-value…)

num-value: A number value.

num-value…: Optionally include one or more additional number values.

Notes

  • DEVSQ divides the sum of the numbers by the number of numbers to get the average (arithmetic mean). The difference (absolute value) between the average and each number is squared and summed and the total is returned.

Example

=DEVSQ(1, 7, 19, 8, 3, 9) returns 196.833333333333.

See alsoSTDEV
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Naudingas?
Ženklų limitas: 250
Didžiausias ženklų limitas yra 250.
Dėkojame už atsiliepimą.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.