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.