Returns the sum of squares of deviations of data points from their sample mean.
Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.
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)Resultado: 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.