Logical values and text representations of numbers that you type directly into the list of arguments are counted.
You can also use a single array or a reference to an array instead of arguments separated by commas.Īrguments can either be numbers or names, arrays, or references that contain numbers.
1 to 255 arguments for which you want to calculate the sum of squared deviations. Number1 is required, subsequent numbers are optional. The DEVSQ function syntax has the following arguments: Returns the sum of squares of deviations of data points from their sample mean.
This article describes the formula syntax and usage of the DEVSQ function in Microsoft Excel.