Returns the sum of squares of deviations of data points from their sample mean.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 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.