The DEVSQ function represents the sum of squares of deviations between the returned data points and their respective sample averages.

Function syntax: DEVSQ(number 1, number2, ...)?

Function parameters: number 1, number 2, ... 1 to 30 parameters for calculating the sum of squares of deviations. You can use comma-separated parameters or a single array, which is an array reference. ?

Note: If an array or reference parameter contains text, logical values or blank cells, these values will be ignored, but cells containing zero values will be counted. ?

Application Case: Yi Rui Education has counted the sales volume last week, and now it needs to calculate the sum of squares of the sales volume.