Returns the sum of squares of deviations of data points from their sample mean.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
DEVSQ(number1, [number2], ...)The DEVSQ function calculates the sum of squared deviations of data points from their arithmetic mean. It is commonly used in statistical analysis to measure the dispersion of a dataset. The formula used is the sum of (x - mean)^2 for all values in the provided arguments.
=DEVSQ(4, 8, 6, 5, 3, 2, 9)Result: 34.85714
Calculates the sum of squares of deviations for the provided set of numbers.
DEVSQ returns the sum of squared deviations, while VAR.P returns the variance, which is the DEVSQ result divided by the count of numbers.