Returns the sum of squares of deviations of data points from their sample mean.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-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.