DEVSQ
Returns the sum of squares of deviations.
StatisticalStatistics & Analysis
What it does
Calculates the sum of squares of deviations of data points from their sample mean.
Syntax
DEVSQ(number1, [number2], ...)
Arguments
number1(number) — First number or range.
Examples
Sum Squared Deviations
Calculate DEVSQ for 1, 2, 3.
FORMULA
=DEVSQ(1, 2, 3)
RESULT
2
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |