Returns the sum of squares of deviations of data points from their sample mean.
الصيغة
DEVSQ(number1, [number2], ...)المعاملات
number1مطلوب
The first number or range of numbers to include in the calculation.
number2اختياري
Additional numbers or ranges up to 255 total arguments.
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.85714Calculates the sum of squares of deviations for the provided set of numbers.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =DEVSQ( followed by your data range or numbers, then close the parenthesis.
Press Enter
Press the Enter key to calculate the sum of squared deviations.
DEVSQ returns the sum of squared deviations, while VAR.P returns the variance, which is the DEVSQ result divided by the count of numbers.